"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> Description: pg_dump/resore has trouble with implicit sequences of
> renamed tables
Yeah, this is addressed in 8.0's pg_dump, but the solution isn't
portable back to existing releases (it needs a new backend function).
regards, tom lane