My mistake, in the future i will consult the FAQ first, though i'm a bit surprised i missed it in the documentation. Much thanks for the help. By generic uses i guess i meant the uses one might have for creating a sequence as an independant object in the database, and not the sequence in a table, and this behavior surely would not frustrate that sort of use. Many thanks.
Matthew Story Quoting Michael Fuhr <[EMAIL PROTECTED]>: > 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 > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
