Re: Disable Triggers

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(at)turbocorp(dot)com
www.turbocorp.com