Обсуждение: BUG #1513: pg_dump -t doesn't include sequences for pre-v8-created tables

The following bug has been logged online:

Bug reference:      1513
Logged by:          Chris Hutchinson
Email address:      hutchinson.chris@gmail.com
PostgreSQL version: 8.0
Operating system:   Linux - Fedora Core 2
Description:        pg_dump -t doesn't include sequences for pre-v8-created
tables
Details:

pg_dump -t includes SERIAL column sequence details for the dumped table when
the table has been created in v8 postgresql.

Tables migrated from an earlier pg version aren't being dumped with their
sequence details. (These tables were created in 7.1, and migrated through
7.3, 7.4 and 8.0)

pg_dump relies on the d.refobjid as owning_tab and d.refobjsubid as
owning_col to track the linkage between SERIAL sequences and their owner
tables.

In the migrated tables these columns don't contain values linking sequences
to their tables, so the sequences aren't included in the dump.

"Chris Hutchinson" <hutchinson.chris@gmail.com> writes:
> pg_dump -t includes SERIAL column sequence details for the dumped table when
> the table has been created in v8 postgresql.

> Tables migrated from an earlier pg version aren't being dumped with their
> sequence details. (These tables were created in 7.1, and migrated through
> 7.3, 7.4 and 8.0)

Yup.  You might try the contrib/adddepend tool to fix this.

            regards, tom lane