Re: disable triggers using psql

Greg Sabino Mullane wrote:
> -----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.

I received the following error:

ERROR: insert or update on table "customer" violates foreign key
constraint "$1"

>
> - --
> Greg Sabino Mullane greg(at)turnstep(dot)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-----
>
>
>

--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson