Skip site navigation (1) Skip section navigation (2)

Re: disabling triggers, constaints and so on

From: Erik Jones <erik(at)myemma(dot)com>
To: Geoffrey <lists(at)serioustechnology(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: disabling triggers, constaints and so on
Date: 2008-02-28 15:22:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Feb 25, 2008, at 2:33 PM, Geoffrey wrote:

> We are still in a pickle with trying to resolve our trigger issues  
> without affecting slony triggers.
> The point is, we need to be able to disable triggers, check  
> constraints, and foreign-key constraints without affecting slony  
> triggers in certain situations.
> This is all running on 7.4.19, thus, it's our understanding that  
> using tgenabled is not going to be a solution.
> Making our triggers smarter doesn't get us all the way there.
> Suggestions?

This may've been suggested to you earlier, but can you drop them and   
re-add them when you're done?

Erik Jones

DBA | Emma®
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at

In response to

pgsql-general by date

Next:From: Erik JonesDate: 2008-02-28 15:35:21
Subject: Re: Regarding interval conversion functions and a seeming lack of usefulness
Previous:From: DeeDate: 2008-02-28 15:18:43
Subject: beginner: what permissions required to install on windows 2000+

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group