Re: foreign keys and RI triggers - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: foreign keys and RI triggers
Date
Msg-id 20050526082805.A5582@megazone.bigpanda.com
Whole thread Raw
In response to Re: foreign keys and RI triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, 26 May 2005, Tom Lane wrote:

> Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> >> Okay, I can't think of cases even with triggers and the like where
> >> removing the check on equal valued rows would give appreciably different
> >> results, but I haven't thought too hard about it.
>
> > Err, except the case that Tom mentions in his message.
>
> But the check could incorporate the same transaction ID test already
> in use.  I think Neil is right that it'd be a win to apply the test
> before enqueueing the trigger instead of after.

Good point.  That would help in many cases anyway.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: foreign keys and RI triggers
Next
From: Stephan Szabo
Date:
Subject: Re: foreign keys and RI triggers