On Sat, Nov 27, 2004 at 10:45:54PM -0600, [EMAIL PROTECTED] 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.html http://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/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
