Re: Insert aborted, but Sequence increased

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Insert aborted, but Sequence increased
Дата
Msg-id 4590.1026228094@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Insert aborted, but Sequence increased  (Hugo Jonker <hugo@gewis.win.tue.nl>)
Список pgsql-bugs
Дерево обсуждения 
Hugo Jonker <hugo@gewis.win.tue.nl> writes:
> Upon doing a faulty INSERT which left a column with default value
> nextval('sequence') unspecified, the INSERT aborted due to an error.
> However, a call had been placed to nextval('sequence'), thus
> increasing the sequence, while this value never got used.

> I certainly didn't expect this.

Then you didn't read the documentation.  Sorry, this is not a bug.

            regards, tom lane

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

Предыдущее
От: eric
Дата:
Сообщение: segfault which isn't supposed to happen (including example code)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: segfault which isn't supposed to happen (including example code)