SERIAL does not ROLLBACK

Поиск
Список
Период
Сортировка
От Muhammad Shariq Muzaffar
Тема SERIAL does not ROLLBACK
Дата
Msg-id 20030312072122.12363.qmail@web41112.mail.yahoo.com
обсуждение исходный текст
Ответы Re: SERIAL does not ROLLBACK  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-sql
hi
i have a table named 'mytable' with a column of type
serial. After inserting tuples in a transaction, when
i rollback the transaction the serial number does not
come back to its original value and next time when i
insert the data, it start with the incremented value.
WHY?? how can i make it to come back to its orignial
value in case of rollback.

thanx in advance...

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Victor Yegorov"
Дата:
Сообщение: Re: Special characters in SQL queries
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: SERIAL does not ROLLBACK