Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump sequence START incorrect? - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump sequence START incorrect?
Date
Msg-id 12820.1014589355@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump sequence START incorrect?  ("Brent R. Matzelle" <bmatzelle@yahoo.com>)
Responses polygon info
List pgsql-general
Tree view 
"Brent R. Matzelle" <bmatzelle@yahoo.com> writes:
> When I perform a pg_dump of any database (PG 7.1.3) the CREATE
> SEQUENCE calls are incorrect.  They all use 'start 1', thus resetting
> the sequence at the beginning.  Is this the desired functionality?  I
> would think that it should set the sequence at the max value of the
> column +1.  Am I missing something?

Yes, the setval() commands executed later on ...

            regards, tom lane

pgsql-general by date:

Previous
From: Eric Webber
Date:
Subject: mod_auth_pg for Apache, and LXP
Next
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: tcpip_socket vs -i