Re: Proper Way to Disable Triggers

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Proper Way to Disable Triggers
Дата
Msg-id 90ddaf175ecc5e11f778904961818988@biglumber.com
обсуждение исходный текст
Ответ на Proper Way to Disable Triggers  (Terry Lee Tucker <terry@chosen-ones.org>)
Список 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@turnstep.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-----



В списке pgsql-general по дате отправления:

Предыдущее
От: Terry Lee Tucker
Дата:
Сообщение: Proper Way to Disable Triggers
Следующее
От: Andreas
Дата:
Сообщение: PG 8.3.x doesn't get build