how to reset the sequences of SERIAL vars? - Mailing list pgsql-general

From Bruno Boettcher
Subject how to reset the sequences of SERIAL vars?
Date
Msg-id 20021101095911.GG22302@bboett.dyndns.org
Whole thread Raw
Responses Re: how to reset the sequences of SERIAL vars?  (Martijn van Oosterhout <kleptog@svana.org>)
Re: how to reset the sequences of SERIAL vars?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
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.

--
ciao bboett
==============================================================
bboett@adlp.org
http://inforezo.u-strasbg.fr/~bboett
===============================================================

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: pam_pgsql, Postfix, imap and PostgreSQL
Next
From: Martijn van Oosterhout
Date:
Subject: Re: how to reset the sequences of SERIAL vars?