Re: disable triggers using psql - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: disable triggers using psql
Date
Msg-id 0b357847c9f0d7d13f8dd5d8977b6df9@biglumber.com
Whole thread Raw
In response to Re: disable triggers using psql  (Geoffrey Myers <lists@serioustechnology.com>)
Responses Re: disable triggers using psql  (Geoffrey Myers <lists@serioustechnology.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: The efficiency of the WAL log writer
Next
From: Ahmed
Date:
Subject: Re: "could not accept SSPI security context"