Re: table is mutating - trigger may not see it

I tried also a before-insert-trigger, but this obviously leads all the more to a FK-violation, because the check for the corresponding PK must be unsuccessful.
The after-insert-trigger "should" work. Is there anything to pay attention concerning the DEFERRABLE INITIALLY DEFERRED - clause? Why in this case does not the FK-constraint check wait until the end of the whole transaction?

Markus Received on Thu Jan 20 2000 - 01:42:52 CST