Postgres Pro
Downloads
Home   >   mailing lists

Re: Insert aborted, but Sequence increased - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Insert aborted, but Sequence increased
Date
Msg-id 4590.1026228094@sss.pgh.pa.us
Whole thread Raw
In response to Insert aborted, but Sequence increased  (Hugo Jonker <hugo@gewis.win.tue.nl>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: eric
Date:
Subject: segfault which isn't supposed to happen (including example code)
Next
From: Tom Lane
Date:
Subject: Re: segfault which isn't supposed to happen (including example code)