From: | Terry Lee Tucker <terry(at)chosen-ones(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Disable Triggers |
Date: | 2008-02-21 18:08:21 |
Message-ID: | 200802211308.21251.terry@chosen-ones.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thursday 21 February 2008 12:56, Scott Marlowe wrote:
> On Thu, Feb 21, 2008 at 9:20 AM, Terry Lee Tucker <terry(at)turbocorp(dot)com>
wrote:
> > Greetings:
> >
> > We have been working diligently toward integrating Slony into our
> > production databases. We've been having trouble with various tables,
> > although being replicated perfectly in the initial replication stage,
> > afterwards, getting out of sync.
> >
> > I have finally figured out what the problem is. We have a Perl process
> > that continually updates certain columns across all databases. That Perl
> > process calls a function we have written called disable_triggers which
> > updates pg_class, setting reltriggers to 0 for the given table, and then
> > later, after the work is complete, resetting reltriggers to the original
> > value. Unfortunately, during this process, the Slony trigger is disabled
> > as well which is causing our problem.
>
> Disabling all triggers is not something you do on a live, running
> database with users accessing and possibly changing it, it's something
> you do to a database during maintenance when no one else is connected.
> You'll have to go with the solution you talked about, i.e. disabling
> individual triggers by name, etc...
>
I have failed to mention that we are disabling all the triggers on a given
table only done during a transaction; thus, it affects no one else.
Thanks for the input...
--
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 | A.M. | 2008-02-21 18:17:54 | Re: Mac ordering with locales |
Previous Message | Andrew Sullivan | 2008-02-21 18:06:36 | Re: Disable Triggers |