BUG #1513: pg_dump -t doesn't include sequences for pre-v8-created tables

From: "Chris Hutchinson" <hutchinson(dot)chris(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1513: pg_dump -t doesn't include sequences for pre-v8-created tables
Date: 2005-03-02 03:59:52
Message-ID: 20050302035952.474CFF0B7B@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1513
Logged by: Chris Hutchinson
Email address: hutchinson(dot)chris(at)gmail(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2005-03-02 08:38:05 Re: Errors using Postgres 7.4.6
Previous Message Tom Lane 2005-03-01 21:20:57 Re: BUG #1512: Assertion failure (lock.c:1537) with SELECT FOR UPDATE and savepoints