Re: SERIAL error

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 <mike(at)fuhr(dot)org>:

> On Sat, Nov 27, 2004 at 10:45:54PM -0600, mstory(at)uchicago(dot)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.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
>