Re: [HACKERS] Disable and enable of table and column constraints

2009-09-14 Thread Kevin Grittner
Martijn van Oosterhout klep...@svana.org wrote: 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. Yeah, as a general rule it doesn't make sense to try to enforce

Re: [HACKERS] Disable and enable of table and column constraints

2009-09-12 Thread Martijn van Oosterhout
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

Re: [HACKERS] Disable and enable of table and column constraints

2009-09-11 Thread Jan Wieck
On 9/10/2009 11:06 AM, Tom Lane wrote: Christopher Browne cbbro...@ca.afilias.info writes: With the ALTER TABLE DISABLE TRIGGER functionality added in 8.3, we already have the ability to do this with foreign key constraints. That feature is a crock that should not be extended, because it

Re: [HACKERS] Disable and enable of table and column constraints

2009-09-10 Thread Christopher Browne
pete...@gmx.net (Peter Eisentraut) writes: On Tue, 2009-09-08 at 16:07 -0400, Alvaro Herrera wrote: Tom Lane wrote: Michael Gould mgo...@intermodalsoftwaresolutions.net writes: It would be nice if we could enable and disable column and table constraints. I believe that you can do this

Re: [HACKERS] Disable and enable of table and column constraints

2009-09-10 Thread Tom Lane
Christopher Browne cbbro...@ca.afilias.info writes: With the ALTER TABLE DISABLE TRIGGER functionality added in 8.3, we already have the ability to do this with foreign key constraints. That feature is a crock that should not be extended, because it leaves it entirely on the user's shoulders

Re: [HACKERS] Disable and enable of table and column constraints

2009-09-09 Thread Rob Wultsch
On Tue, Sep 8, 2009 at 1:07 PM, Alvaro Herreraalvhe...@commandprompt.com wrote: Tom Lane wrote: Michael Gould mgo...@intermodalsoftwaresolutions.net writes: It would be nice if we could enable and disable column and table constraints.  I believe that you can do this in Oracle but this is

Re: [HACKERS] Disable and enable of table and column constraints

2009-09-09 Thread Kevin Grittner
Alvaro Herrera alvhe...@commandprompt.com wrote: Both DB2 and Oracle have an ENFORCE setting for constraints, and a MySQL blog hinted some time ago that it might be in SQL 201x. If I remember correctly, Sybase never checks the existing data when you add a constraint of any type (except for a

[HACKERS] Disable and enable of table and column constraints

2009-09-08 Thread Michael Gould
It would be nice if we could enable and disable column and table constraints. I believe that you can do this in Oracle but this is very handy for testing stored procedures and other external processes. Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC

Re: [HACKERS] Disable and enable of table and column constraints

2009-09-08 Thread Tom Lane
Michael Gould mgo...@intermodalsoftwaresolutions.net writes: It would be nice if we could enable and disable column and table constraints. I believe that you can do this in Oracle but this is very handy for testing stored procedures and other external processes. Drop the constraint and re-add

Re: [HACKERS] Disable and enable of table and column constraints

2009-09-08 Thread Alvaro Herrera
Tom Lane wrote: Michael Gould mgo...@intermodalsoftwaresolutions.net writes: It would be nice if we could enable and disable column and table constraints. I believe that you can do this in Oracle but this is very handy for testing stored procedures and other external processes. Drop the

Re: [HACKERS] Disable and enable of table and column constraints

2009-09-08 Thread Peter Eisentraut
On Tue, 2009-09-08 at 16:07 -0400, Alvaro Herrera wrote: Tom Lane wrote: Michael Gould mgo...@intermodalsoftwaresolutions.net writes: It would be nice if we could enable and disable column and table constraints. I believe that you can do this in Oracle but this is very handy for