begin/end/abort work for sequences?

Поиск
Список
Период
Сортировка
От Kyle
Тема begin/end/abort work for sequences?
Дата
Msg-id 199906300411.WAA22152@actarg.com
обсуждение исходный текст
Список pgsql-sql
I assumed that wrapping a call to nextval() in a transaction would allow
me to roll back the update of the sequence.  But when I do the following:

  begin;
  select nextval('po_seq');
  abort;

The sequence po_seq is advancing to the next value even though the
transaction was aborted.  If I put other things like updates, inserts, etc.
inside the transaction, they seem to be rolled back OK, but not the
update of the sequence.

Am I doing something wrong?

 ----------------------------------------------------
 Kyle Bateman       President, Action Target Inc.
 "Viva Yo!"         kyle@actarg.com (801)377-8033x101
 ----------------------------------------------------

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Escaping w/i regular expressions
Следующее
От: "Ansley, Michael"
Дата:
Сообщение: RE: pgsql-sql-digest V1 #276