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

Re: Sequence increased before constraint check

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: <davidl(at)ayamba(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Sequence increased before constraint check
Date: 2001-02-14 18:46:43
Message-ID: Pine.LNX.4.30.0102141945450.1112-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-bugs
> When a table is created with a serial column and another column that
> has a foreign key constraint, if the foreign key check fails, the
> sequence will still be updated.  This results in potential gaps in the
> serial column.

This is not a bug.  If you cannot have gaps in your number sequence then
you cannot use serial.

-- 
Peter Eisentraut      peter_e(at)gmx(dot)net       http://yi.org/peter-e/


In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-02-14 19:13:43
Subject: Re: Explain reports unexpected results with inheritance
Previous:From: David LynnDate: 2001-02-14 18:29:03
Subject: Bug #194 and #195 missing version

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