Postgres Pro
Downloads
Home   >   mailing lists

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

From Thom Brown
Subject Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE
Date
Msg-id AANLkTimcUk3ZShGC8Wcu8itdnsq-jsJLz0YkefHslywC@mail.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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
2010/6/23 Grzegorz Jaśkiewicz <gryzman@gmail.com>:
> I do understand what you are saying, but still it is highly
> unintuitive. Since trigger is BEFORE, developer will expect that data
> to be there.
>

Yes, I'm still not exactly sure why it's seeing uncommitted changes. :/

Thom

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE
Next
From: Devrim GUNDUZ
Date:
Subject: Re: missing uuid functions in postgresql-contrib RPM for linux?