Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group