Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrian Klaver
Subject Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE
Date
Msg-id 201006240746.36548.adrian.klaver@gmail.com
Whole thread Raw
In response to Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
Tree view 
On Thursday 24 June 2010 7:40:22 am Grzegorz Jaśkiewicz wrote:
> that Id refers to 'name' column that I need. There still is FK on it,
> so basically it is broken inside transaction, from trigger's
> perspective.

I understand this part. What I am saying is think about reversing your point of
view. Instead of pulling the information from foob, push out the information
from foob.

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE
Next
From: Tom Lane
Date:
Subject: Re: Could not locate a valid checkpoint record