Re: disable triggers using psql
От | Greg Sabino Mullane |
---|---|
Тема | Re: disable triggers using psql |
Дата | |
Msg-id | 28fd6ffbd42d0f6091294c33282a3868@biglumber.com обсуждение исходный текст |
Ответ на | Re: disable triggers using psql (Geoffrey Myers <lists@serioustechnology.com>) |
Ответы |
Re: disable triggers using psql
Re: disable triggers using psql |
Список | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > I'm not sure how to address this. I'm not exactly sure where to place > session_replication_role. It's very close to the top of the file: Is this a pg_dumpall? A \connect later on will reset the session_replication_role. If so, add the SET right after the \connect. Alternatively, you could create a special user to invoke psql as, which has: ALTER USER dangerous_bob SET session_replication_role = replica; Be *very* careful with that account though, as using it for anything other than this special case could be very bad. - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201102181408 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAk1ew9MACgkQvJuQZxSWSshETwCg2oEEicHhokORuQRl3sxkLkpj ghIAnRe02LCuyyRlyzvKZ67QCYUyfPzC =H9Wb -----END PGP SIGNATURE-----
В списке pgsql-general по дате отправления: