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