On Sat, Nov 27, 2004 at 10:45:54PM -0600, mstory@uchicago.edu wrote:
>
> I'm using v. 7.4.2, and am encountering a problem with serial types. On an
> insert into a table that results in failure for any number of reasone (mostly
> violation of contraints) I've found that the Sequence for the column of type
> serial will still bump the value up once.
This behavior is intentional. See the PostgreSQL documentation and
the FAQ:
http://www.postgresql.org/docs/7.4/static/functions-sequence.htmlhttp://www.postgresql.org/docs/faqs/FAQ.html#4.15.4
> Anyway, was wondering if this needed to be reported as a bug? Seems
> to cause problems for certain generic uses for the serial type.
What do you mean by "generic uses"? Sequences are for obtaining
unique values; problems caused by assuming anything else are almost
certainly application bugs.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/