Re: [BUGS] Sequence increased before constraint check

2001-02-14 Thread Peter Eisentraut
> 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

[BUGS] Sequence increased before constraint check

2001-02-14 Thread pgsql-bugs
David Lynn ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Sequence increased before constraint check Long Description When a table is created with a serial column and another column that has a foreign key constraint, if the f