Re: PostgreSQL 7.4.2 allows foreign key violation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Markus Bertheau <twanger(at)bluetwanger(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 7.4.2 allows foreign key violation
Date: 2004-08-06 17:23:23
Message-ID: 20652.1091813003@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> writes:
> On Fri, 6 Aug 2004, Tom Lane wrote:
>> Already does what? I see nothing in there that would override either
>> triggers or rules...

> It's not for overriding the triggers or rules, but instead checking that
> the post action state is valid (by running the no action code which
> makes sure that either another row now has the pk value or that there are
> no longer any matching rows).

Oh, I see. Seems an awfully expensive solution though :-(

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2004-08-06 17:42:43 Re: PostgreSQL 7.4.2 allows foreign key violation
Previous Message Stephan Szabo 2004-08-06 17:13:18 Re: PostgreSQL 7.4.2 allows foreign key violation