The following bug has been logged online: Bug reference: 3296 Logged by: S. Robert James Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
