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

From Satoshi Nagayasu
Subject Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)
Date
Msg-id 42C4F62D.9050002@nttdata.co.jp
Whole thread Raw
In response to Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-patches
> I said why _shouldn't_.  I was agreeing with you.

Oops. Sorry.

I don't know why only super-user shold be able to enable/disable tirggers.

I believe the table owner want to enable/disable triggers,
because I always need it.

Loading huge data set into the table with triggers(or fk) is very painful.

Christopher Kings-Lynne wrote:
>
> Satoshi Nagayasu wrote:
>
>>>The table owner can drop and create triggers - so why shouldn't they be
>>>able to enable and disable them?
>>
>>
>>For convenience or easy operation.
>>
>>I believe the user doesn't like to create same triggers again and again.
>
>
> I said why _shouldn't_.  I was agreeing with you.
>
> Chris
>
>


--
NAGAYASU Satoshi <nagayasus@nttdata.co.jp>

pgsql-patches by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)
Next
From: Neil Conway
Date:
Subject: Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)