On Thu, 17 Jul 2008, Ismael .... wrote: > So is there no other way to do it but to verify the integrity using triggers > and drop the referential constraints? Well, you could do something using a before delete trigger on the referencing table that returns NULL to avoid the delete as well, but making it only prevent the deletions caused by the referential constraints might be difficult.
