Re: how to reset the sequences of SERIAL vars?

On 1 Nov 2002 at 10:59, Bruno Boettcher wrote:
> when inserting from backup the tables are filled with all fields, this
> means alos those defined as serial, but without using nextval...
>
> this means that the sequences for those vars are out of synch with the
> table after the backup...
>
> now there was a sequence to set this up and runnign again, but i cna't
> find it in my papers anymore, so if someone could kindly point me out
> on how to set up the correct values un the sequence i will be really
> grateful.

From createsequence.html in postgresql manual

---------------------------------------
Update the sequence value after a COPY FROM:

BEGIN;
COPY distributors FROM 'input_file';
SELECT setval('serial', max(id)) FROM distributors;
END;
---------------------------------------

Also look at functions-sequence.html for more reference.

HTH

Bye
Shridhar

--
Barometer, n.: An ingenious instrument which indicates what kind of weather we
are having. -- Ambrose Bierce, "The Devil's Dictionary"