Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)

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