Re: Disable Triggers - Mailing list pgsql-general

From Terry Lee Tucker
Subject Re: Disable Triggers
Date
Msg-id 200802211727.14391.terry@turbocorp.com
Whole thread Raw
In response to Re: Disable Triggers  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
On Thursday 21 February 2008 17:07, Andrew Sullivan wrote:
> On Thu, Feb 21, 2008 at 04:35:28PM -0500, Geoffrey wrote:
> > How might we find out which release it was fixed in?  Back patching
> > 7.4.19 with the fix might be easier then trying to move up to the fixed
> > version.
>
> According to HISTORY, there was a significant fix in this area in 8.1:
>
>     * Add "ALTER TABLE ENABLE/DISABLE TRIGGER" to disable triggers
>            (Satoshi Nagayasu)
>
> I think your chances of successfully back-porting something like that from
> 8.1 to 7.4.x are way lower than your chances of fixing your application to
> use a later database system.  Also, if you get off 7.4, you get rid of the
> horrifying checkpoint storms in that version, and get a whack of other
> improvements and bugfixes.
>

Yea, upgrading is slated to begin in April. We needed to get replication going
now. You've been a big help. Thanks...
--
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@turbocorp.com
www.turbocorp.com

pgsql-general by date:

Previous
From: tuanhoanganh
Date:
Subject: Re: Function parameters change when update to 8.3
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: client_encoding