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

BUG #3296: CASCADING FKs dont DEFER

From: "S(dot) Robert James" <srobertjames(at)vesaria(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3296: CASCADING FKs dont DEFER
Date: 2007-05-22 08:24:00
Message-ID: 200705220824.l4M8O0nT067095@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3296
Logged by:          S. Robert James
Email address:      srobertjames(at)vesaria(dot)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

Responses

pgsql-bugs by date

Next:From: Max KhonDate: 2007-05-22 08:29:50
Subject: Re: ON DELETE CASCADE with multiple paths
Previous:From: Tom LaneDate: 2007-05-22 02:51:47
Subject: Re: BUG #3277: error occurs between different versions

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