Re: disable triggers using psql

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: disable triggers using psql
Дата
Msg-id 0b357847c9f0d7d13f8dd5d8977b6df9@biglumber.com
обсуждение исходный текст
Ответ на Re: disable triggers using psql  (Geoffrey Myers <lists@serioustechnology.com>)
Ответы Re: disable triggers using psql  (Geoffrey Myers <lists@serioustechnology.com>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> We were trying to accomplish this without having to hack the dump to
> much.  We attempted adding:
>
> set local session_replication_role = replica;
>
> But that does not seem provide the expected relief.

How exactly did this fail? This should absolutely disable all
triggers for you, unless you've mucked with the triggers
and set them to replica.

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201102171053
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk1dRKIACgkQvJuQZxSWSsir0wCfQZmZkDrYBYVffyYBGYoqA/RT
VRMAoLG497FaRU7gOkpM394UT7xksXzk
=f9co
-----END PGP SIGNATURE-----



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: The efficiency of the WAL log writer
Следующее
От: Ahmed
Дата:
Сообщение: Re: "could not accept SSPI security context"