Re: foreign keys and RI triggers

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