On Thursday 21 February 2008 13:05, Andrew Sullivan wrote: > > > > Unless I get a better idea, I'm going to change the disable_triggers > > function to duplicate all the records in pg_trigger belonging to a given > > table, delete the records except for the Slony trigger, update pg_class > > setting reltriggers to 1, do the work, and then restore everything with a > > call to > > enable_triggers. Does this sound reasonable to you? > > I expect you're going to have to get everyone to disconnect after that, > because the triggers oids will all have changed and you'll get errors to > that effect. Also, are there these triggers on the slony replicas? You > really need to be doing DROP TRIGGER/STORE TRIGGER operations if so. > Otherwise, very surprising things may happen. > Gee, I hadn't thought about that. Back to the drawing board... Thanks for the help.
-- 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 [EMAIL PROTECTED] www.turbocorp.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
