Re: Behaviour

On 18 Jul 2002, [ISO-8859-1] Stphane Raimbault wrote:

> Hi,
>
> I have the following tables :
> CREATE TABLE tournee (
> no_tournee SERIAL PRIMARY KEY);
>
> CREATE TABLE fab_tournee (
> id SERIAL PRIMARY KEY,
> id_fab INTEGER REFERENCES fabrication ON DELETE CASCADE,
> no_tournee INTEGER REFERENCES tournee ON DELETE CASCADE);
>
> When I insert a new record into 'fab_tournee' whereas the field
> 'no_tournee' doesnt exist in 'tournee', I have this message :
>
> ERROR: <unnamed> referential integrity violation - key referenced
> from fab_tournee not found in tournee
>
> but 'id' increments in 'fab_tournee'.
>
> Is it a normal behaviour ?

Yes. SERIAL uses a sequence for doing its value choice (it's
effectively similar to an integer column with a default) and
sequences do not rollback with transactions (due to concurrency
concerns). You can find more info about this in the archives.