| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Disable Triggers |
| Date: | 2008-02-21 22:07:05 |
| Message-ID: | 20080221220705.GA19463@crankycanuck.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Terry Lee Tucker | 2008-02-21 22:27:14 | Re: Disable Triggers |
| Previous Message | Justin | 2008-02-21 21:37:47 | need some help on figuring out how to write a query |