Re: SERIAL error - Mailing list pgsql-general

From Mike Mascari
Subject Re: SERIAL error
Date
Msg-id 41A95D3B.1050901@mascari.com
Whole thread Raw
In response to SERIAL error  (mstory@uchicago.edu)
List pgsql-general
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 is FAQ item number 4.15.4:

http://www.postgresql.org/docs/faqs/FAQ.html#4.15.4

HTH,

Mike Mascari


pgsql-general by date:

Previous
From: mstory@uchicago.edu
Date:
Subject: SERIAL error
Next
From: Michael Fuhr
Date:
Subject: Re: SERIAL error