Re: Proper Way to Disable Triggers

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Proper Way to Disable Triggers
Date: 2008-04-03 00:22:30
Message-ID: 90ddaf175ecc5e11f778904961818988@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

> I am in the process of converting our 7.4.19 database to 8.3.1. We have
> various scenarios where we need to disable all triggers for a given table
> except for the Slony replication triggers. I'm looking for advice for the
> "proper" way to do this.

See the new new session_replication option:

http://www.postgresql.org/docs/current/static/runtime-config-client.html#GUC-SESSION-REPLICATION-ROLE

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200804022021
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkf0IxwACgkQvJuQZxSWSsjt/gCgk+57cVz9IO6J3bSeka9jEiuB
W60An2QKLR87/Rer+gfnO9LBqIU4S5jj
=ZOcE
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Mayer 2008-04-03 00:42:08 Re: modules
Previous Message Andrew Dunstan 2008-04-03 00:15:49 Re: modules