Postgres Pro
Downloads
Home   >   mailing lists

BUG #3296: CASCADING FKs dont DEFER - Mailing list pgsql-bugs

From S. Robert James
Subject BUG #3296: CASCADING FKs dont DEFER
Date
Msg-id 200705220824.l4M8O0nT067095@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3296: CASCADING FKs dont DEFER  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3296
Logged by:          S. Robert James
Email address:      srobertjames@vesaria.com
PostgreSQL version: 8.1
Operating system:   Linux
Description:        CASCADING FKs dont DEFER
Details:

If a FK is set to ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, it does
not honor the defer.

That is, if you DELETE a record and then INSERT it back, you still get a FK
deletion of the referencing record.  This seems to ignore DEFERRED.

I did not seem to get this on 8.2 / Windows

pgsql-bugs by date:

Previous
From: Max Khon
Date:
Subject: Re: ON DELETE CASCADE with multiple paths
Next
From: adam terrey
Date:
Subject: Inconsistant SQL results - Suspected error with query planing or query optimisation.