Re: Disabling triggers / constraints

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: kell_pt(at)users(dot)sourceforge(dot)net, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Disabling triggers / constraints
Date: 2004-05-21 03:21:13
Message-ID: 40AD75A9.7060603@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Jorge Pereira 2004-05-21 04:28:16 Re: Disabling triggers / constraints
Previous Message Bruce Momjian 2004-05-21 03:00:44 Re: Disabling triggers / constraints