#388: Reset auto_increment value when truncating table in PostgreSQL.
#388: Reset auto_increment value when truncating table in PostgreSQL.

Note that this change was introduced in PostgreSQL 8.4, which was released in September 2009. I would actually claim that with the small share of FluxBB users that use PostgreSQL for their database, this should not be a problem.
fluxbb/database