Re: Disable Triggers - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Disable Triggers
Date
Msg-id 20080221220705.GA19463@crankycanuck.ca
Whole thread Raw
In response to Re: Disable Triggers  (Geoffrey <lists@serioustechnology.com>)
Responses Re: Disable Triggers
List pgsql-general
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.

A


pgsql-general by date:

Previous
From: Justin
Date:
Subject: need some help on figuring out how to write a query
Next
From: Dee
Date:
Subject: Re: Install problem w/8.3 on windows 2000 : application failed to initialize properly (0xc0000022)