Postgres Pro
Downloads
Home   >   mailing lists

Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE
Date
Msg-id AANLkTin79_wj1KcfqG56ikqIKxMh7zVYPmuG3nuFAoLz@mail.gmail.com
Whole thread Raw
In response to Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE  (Thom Brown <thombrown@gmail.com>)
Responses Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE  (Thom Brown <thombrown@gmail.com>)
List pgsql-general
Tree view 
it is confusing to me, because I thought triggers are firring BEFORE
anything goes away. So I assume that all data is still going to be
visible to the trigger, as it is firing BEFORE. The only thing is, it
looks like the FKs are doing the deletion and than things are handed
over to triggers.

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE
Next
From: Craig Ringer
Date:
Subject: Re: High Availability with Postgres