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?
Re: how to reset the sequences of SERIAL vars? |
Список | 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 по дате отправления: