Re: Fix disabled triggers with deferred constraints

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Elliot Lee <sopwith(at)redhat(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Fix disabled triggers with deferred constraints
Date: 2002-05-14 00:47:08
Message-ID: 21558.1021337228@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Elliot Lee <sopwith(at)redhat(dot)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?

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tatsuo Ishii 2002-05-14 02:08:04 Re: getopt_long patch for pg_dump and psql
Previous Message Elliot Lee 2002-05-13 19:20:45 Fix disabled triggers with deferred constraints