Re: disabled, deferred triggers

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: disabled, deferred triggers
Date: 2003-01-08 22:28:29
Message-ID: 200301082228.h08MSTX15060@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Patch applied. Thanks.

---------------------------------------------------------------------------

Neil Conway wrote:
> This trivial patch implements disabled, deferred triggers, per my
> proposal on -hackers a couple days ago. The 'tgenabled' status of the
> trigger is consulted when the trigger is added to the deferred queue
> (i.e. when the event occurs that fires the trigger), not when the
> deferred event is executed.
>
> No regression tests, as another bug prevents them (the pg_trigger row
> for a trigger is only loaded once per session, so any changes to it are
> not noticed unless the client disconnects and reconnects).
>
> Cheers,
>
> Neil
> --
> Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC
>
>

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-01-08 22:29:25 Re: disabled, deferred triggers
Previous Message Tom Lane 2003-01-08 22:23:54 Re: minor doc improvements