Re: Disabling triggers / constraints - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: Disabling triggers / constraints
Date
Msg-id 40AD75A9.7060603@familyhealth.com.au
Whole thread Raw
In response to Re: Disabling triggers / constraints  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Disabling triggers / constraints
Re: Disabling triggers / constraints
List pgsql-patches
> Yes, agreed.  I think we decided that super-user-only could disable
> trigger on a global basis.  I prevent folks from mucking with the system
> tables to do it.

It should be a per-table thing:

ALTER TABLE blah [ DISABLE | ENABLE ] [ALL | FOREIGN KEY ] TRIGGERS;

Chris


pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Disabling triggers / constraints
Next
From: Jorge Pereira
Date:
Subject: Re: Disabling triggers / constraints