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

From Neil Conway
Subject Re: Fix disabled triggers with deferred constraints
Date
Msg-id 87it2mfy59.fsf@klamath.dyndns.org
Whole thread Raw
In response to Re: Fix disabled triggers with deferred constraints  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Fix disabled triggers with deferred constraints
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
> > 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?

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-patches by date:

Previous
From: Pierre-Yves LANDURE
Date:
Subject: Polygon contrib
Next
From: Neil Conway
Date:
Subject: Re: CLUSTER patch and regression test