On Wednesday 09 April 2008 11:00, Greg Sabino Mullane wrote: > > I have a situation where an external process needs to disable the firing > > of triggers on a table. > > ... > > > session_replication_role is set to "origin". I thought this was supposed > > to be fixed in later versions of Postgres (I'm converting from 7.4.19 to > > 8.3.1), so apparently I'm missing something. > > You want: SET session_replication_role to 'replica'; Thanks for the response Greg. Should the session_replication_role be restored to "origin", when the process is complete? > > -- > Greg Sabino Mullane greg@xxxxxxxxxxxx > PGP Key: 0x14964AC8 200804091058 > http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 404-6987 terry@xxxxxxxxxxxxx www.turbocorp.com
