Skip site navigation (1) Skip section navigation (2)

Re: SERIAL error

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: mstory(at)uchicago(dot)edu
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SERIAL error
Date: 2004-11-28 05:08:11
Message-ID: 41A95D3B.1050901@mascari.com (view raw or flat)
Thread:
Lists: pgsql-general
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 is FAQ item number 4.15.4:

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

HTH,

Mike Mascari


In response to

pgsql-general by date

Next:From: Michael FuhrDate: 2004-11-28 05:10:41
Subject: Re: SERIAL error
Previous:From: mstoryDate: 2004-11-28 04:45:54
Subject: SERIAL error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group