Re: transaction processing after error in statement

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: transaction processing after error in statement
Дата
Msg-id 1068493505.25089.48.camel@jester
обсуждение исходный текст
Ответ на Re: transaction processing after error in statement  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Список pgsql-sql
Дерево обсуждения 
> Although i am not aware of the roots of this discussion but would like
> to
> comment at this point .
> 
> When we work with sequences an aborted transaction does have
> a permanent effect on the last value  of sequence. Is this behaviour 
> not a violation of above defination of transaction ?

I believe you are correct, which is probably why Oracle offers
serialized sequences for those who want them to be. Sequences have been
explicitly documented as functioning the way they do as a concession for
performance.

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

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: transaction processing after error in statement
Следующее
От: "Nick Fankhauser"
Дата:
Сообщение: Is there a more elegant way to write this query?...