Re: Fix disabled triggers with deferred constraints - Mailing list pgsql-patches

From Tom Lane
Subject Re: Fix disabled triggers with deferred constraints
Date
Msg-id 16877.1028738783@sss.pgh.pa.us
Whole thread Raw
In response to Re: Fix disabled triggers with deferred constraints  (Neil Conway <nconway@klamath.dyndns.org>)
Responses Re: Fix disabled triggers with deferred constraints  (Neil Conway <nconway@klamath.dyndns.org>)
List pgsql-patches
Neil Conway <nconway@klamath.dyndns.org> writes:
> Elliot Lee <sopwith@redhat.com> writes:
> About as obscure a bug as you can get - without the patch, disabled
> triggers for deferred constraints get run anyways. The patch is simple and
> works, but the "right" (and more complicated) fix may involve not adding
> the trigger to event->dte_item to begin with.
>
> I remember looking at this issue and not doing anything because I
> couldn't decide whether the test for enabled status should occur when
> the trigger is queued or when it is executed --- or, perhaps, both?
> Is there anything in the standard about it?
>>
>> Was there any agreement on this?

> Any update on this?

I think we're still waiting for someone to figure out what the behavior
should be per spec.

            regards, tom lane

pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: Re: CLUSTER patch and regression test
Next
From: Neil Conway
Date:
Subject: Re: Fix disabled triggers with deferred constraints