after inserting bulk data, Select Max of the sequence.
SELECT setval('abc_xyz_seq', max value);
should get the sequence in synchro.
Rory Campbell-Lange wrote:
> I have problems after exporting then importing data into newly created
> databases that the sequence and the indexed serial fields get out of
In response to
pgsql-novice by date
|Next:||From: Norman Khine||Date: 2002-09-22 21:17:59|
|Subject: Subselect query for a multi table insert single query|
|Previous:||From: Tom Lane||Date: 2002-09-20 23:57:18|
|Subject: Re: table corruption... :( |