On Wednesday 09 April 2008 13:12, Tom Lane wrote: > Terry Lee Tucker <terry@xxxxxxxxxxxxxxx> writes: > > My question is: When tgenabled is set to "D", how does that setting > > interact with session_replication_role and, is there a way to use > > tgenabled with a setting of "D" to prevent a particular trigger from > > firing. Using ALTER TABLE to disable the trigger won't work because the > > whole table is locked during the transaction and I only want the disabled > > trigger to apply to the current transaction in the current session. > > I'll bet you're missing a relcache flush operation. I don't think an > update on pg_trigger will cause that by itself. > > regards, tom lane Thanks for the response Tom. I hate to be dense, but I really don't have a clue as to what you are saying. I can't find anything in the docs regarding "relcache flush". I have to get this issue resolved as our system uses a Perl process to keep certain columns in certain tables in sync across several databases, so, if you can point me in the right direction, that would be great. -- 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
