Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items) - Mailing list pgsql-patches

From Andreas Pflug
Subject Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)
Date
Msg-id 42C55192.3070200@pse-consulting.de
Whole thread Raw
In response to enable/disable trigger (Re: Fwd: [HACKERS] Open items)  (Satoshi Nagayasu <nagayasus@nttdata.co.jp>)
List pgsql-patches
Satoshi Nagayasu wrote:

>Hi all,
>
>Here is a first patch to allow these commands.
>
>
>
>>ALTER TABLE <table> ENABLE TRIGGER <trigname>
>>ALTER TABLE <table> DISABLE TRIGGER <trigname>
>>
>>
>
>Bruce said to allow them only super-user,
>but currently this patch allows also the table owner.
>
>
>
It would be convenient if all triggers could be disabled with a single
command. More precise:
option 1: All triggers except for RI triggers (EN/DISABLE TRIGGER ALL)
option 2: really all triggers including RI triggers (superuser only)

Regards,
Andreas




pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: pl/pgsql: END verbosity [patch]
Next
From: Karel Zak
Date:
Subject: Re: Implementing SELECT FOR UPDATE [NOWAIT]