Re: disabling triggers, constaints and so on - Mailing list pgsql-general

From Erik Jones
Subject Re: disabling triggers, constaints and so on
Date
Msg-id 3157CAB9-615D-488C-B2F9-111BBE7906DF@myemma.com
Whole thread Raw
In response to disabling triggers, constaints and so on  (Geoffrey <lists@serioustechnology.com>)
List 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®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com




pgsql-general by date:

Previous
From: Dee
Date:
Subject: beginner: what permissions required to install on windows 2000+
Next
From: Erik Jones
Date:
Subject: Re: Regarding interval conversion functions and a seeming lack of usefulness