how to reset the sequences of SERIAL vars?

Поиск
Список
Период
Сортировка
От Bruno Boettcher
Тема how to reset the sequences of SERIAL vars?
Дата
Msg-id 20021101095911.GG22302@bboett.dyndns.org
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: pam_pgsql, Postfix, imap and PostgreSQL
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: how to reset the sequences of SERIAL vars?