Re: how to reset the sequences of SERIAL vars?

On Fri, Nov 01, 2002 at 10:59:11AM +0100, Bruno Boettcher wrote:
> Hello,
>   its a FAQ i know, but i couldn't find it on the site or the docu...
>   this problem arises mainly after a backup was played in again....
>
>   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.

The way to change a sequence is to use setval. If you're restoring from a
backup, make sure that when you make the backup using pg_dump you also dump
the sequence. This will produce the appropriate setval() command.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.