From: | Terry Lee Tucker <terry(at)turbocorp(dot)com> |
---|---|
To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Disable Triggers |
Date: | 2008-02-21 18:28:29 |
Message-ID: | 200802211328.29802.terry@turbocorp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
terry(at)turbocorp(dot)com
www.turbocorp.com
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2008-02-21 18:39:36 | Re: Disable Triggers |
Previous Message | A.M. | 2008-02-21 18:17:54 | Re: Mac ordering with locales |