Re: Enable/Disable triggers - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Enable/Disable triggers
Date
Msg-id 200403041633.i24GXCW14924@candle.pha.pa.us
Whole thread Raw
In response to Enable/Disable triggers  (Josué Maldonado <josue@lamundial.hn>)
List pgsql-general
Josu� Maldonado wrote:
> Hello list,
>
> Is there a way to disable temporary all the triggers of a table or
> database and then enable them back?

See the PostgreSQL cookbook for sample implementation function.  You
have to muck with the system tables.  This is on the TODO list.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: REFERENCES error message complaint, suggestion
Next
From: Tom Lane
Date:
Subject: Re: Aggregate function capability with \d in psql