Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump incorrect sequence value - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump incorrect sequence value
Date
Msg-id 21890.1062605158@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump incorrect sequence value  ("Joshua L. San Juan" <josh.sanjuan@q-linux.com>)
List pgsql-general
Tree view 
"Joshua L. San Juan" <josh.sanjuan@q-linux.com> writes:
> but in the second table - the sequence was incorrect:
> SELECT pg_catalog.setval ('table2_id_seq', 1, true);

It seems fairly hard to believe that what pg_dump emitted was not the
actual state of the sequence object.  Why do you think this is incorrect?

            regards, tom lane

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Using oids
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Using oids