> 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 Lane||Date: 2001-02-14 19:13:43|
|Subject: Re: Explain reports unexpected results with inheritance |
|Previous:||From: David Lynn||Date: 2001-02-14 18:29:03|
|Subject: Bug #194 and #195 missing version|