Re: PostgreSQL 7.4.2 allows foreign key violation - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL 7.4.2 allows foreign key violation
Date
Msg-id 20652.1091813003@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL 7.4.2 allows foreign key violation  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: PostgreSQL 7.4.2 allows foreign key violation  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: PostgreSQL 7.4.2 allows foreign key violation  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-general
Stephan Szabo <sszabo@megazone.bigpanda.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

pgsql-general by date:

Previous
From: ruben
Date:
Subject: Re: Slow after VACUUM, fast after DROP-CREATE INDEX
Next
From: Daniel S
Date:
Subject: Re: New to Postgres