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

From Christopher Kings-Lynne
Subject Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)
Date
Msg-id 42C4F0D3.2080004@familyhealth.com.au
Whole thread Raw
In response to enable/disable trigger (Re: Fwd: [HACKERS] Open items)  (Satoshi Nagayasu <nagayasus@nttdata.co.jp>)
Responses Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)  (Satoshi Nagayasu <nagayasus@nttdata.co.jp>)
Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
>>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.

The table owner can drop and create triggers - so why shouldn't they be
able to enable and disable them?

Chris


pgsql-patches by date:

Previous
From: Satoshi Nagayasu
Date:
Subject: enable/disable trigger (Re: Fwd: [HACKERS] Open items)
Next
From: Satoshi Nagayasu
Date:
Subject: Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)