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
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
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
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
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
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
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
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
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
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
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
11 matches
Mail list logo
