Re: Disable and enable of table and column constraints - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Disable and enable of table and column constraints
Date
Msg-id 20090912120634.GA5285@svana.org
Whole thread Raw
In response to Re: Disable and enable of table and column constraints  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Disable and enable of table and column constraints
List pgsql-hackers
On Thu, Sep 10, 2009 at 04:24:15PM -0400, Jan Wieck wrote:
> The feature was originally intended to be a clean way of avoiding
> interferences of triggers and/or foreign keys with replication systems
> that work on the user level (like Bucardo, Londiste and Slony). The only
> way to break foreign keys in that scenario is to replicate a referencing
> table without replicating the corresponding PK table.

FWIW, I find the ability in Slony to configure triggers so they work or
not depending on the replication role to be extremely useful. Absolutely
a major positive feature.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: COPY enhancements
Next
From: Grzegorz Jaskiewicz
Date:
Subject: Re: clang's static checker report.