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

From Tom Lane
Subject Re: foreign keys and RI triggers
Date
Msg-id 2583.1117121201@sss.pgh.pa.us
Whole thread Raw
In response to Re: foreign keys and RI triggers  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: foreign keys and RI triggers  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: foreign keys and RI triggers  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Regression failures: time, timetz, horology
Next
From: Stephan Szabo
Date:
Subject: Re: foreign keys and RI triggers