Re: Bug #699: pg_dump not reporting correct start value for sequence - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #699: pg_dump not reporting correct start value for sequence
Date
Msg-id 1897.1025099614@sss.pgh.pa.us
Whole thread Raw
In response to Bug #699: pg_dump not reporting correct start value for sequence  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.org writes:
> This causes problems for me as I use the dump to check if the schema is up to date.

Then don't do that, or more accurately try looking at the setval not the
CREATE SEQUENCE.

The START value of a sequence isn't saved anywhere; it's merely the
initial value of the running counter, and so pg_dump cannot reliably
reconstruct it for you.  I do not consider this a bug.  pg_dump's
charter is to reproduce the database state when the script is reloaded,
and it does so.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Gordon Luk
Date:
Subject: [Fwd: [GENERAL] [Please Help!!!!!!!!] Problem in Chinese (Big5)!!! Version 7.2.1 (come with Redhat 7.3)]
Next
From: "Alfredo"
Date:
Subject: Please I want to unsusribe me from this list