Re: pg_dump sequence START incorrect?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump sequence START incorrect?
Date: 2002-02-24 22:22:35
Message-ID: 12820.1014589355@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Brent R. Matzelle" <bmatzelle(at)yahoo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thalis A. Kalfigopoulos 2002-02-24 22:30:11 Re: tcpip_socket vs -i
Previous Message Thomas T. Thai 2002-02-24 22:22:21 help with getting index scan