>Martijn van Oosterhout 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
constraints on a replica
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 for
On 9/10/2009 11:06 AM, Tom Lane wrote:
Christopher Browne 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 u
Christopher Browne 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 whether the constraint
pete...@gmx.net (Peter Eisentraut) writes:
> On Tue, 2009-09-08 at 16:07 -0400, Alvaro Herrera wrote:
>> Tom Lane wrote:
>> > Michael Gould 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
Alvaro Herrera 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 unique constraint or
pri
On Tue, Sep 8, 2009 at 1:07 PM, Alvaro
Herrera wrote:
> Tom Lane wrote:
>> Michael Gould 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 ext
On Tue, 2009-09-08 at 16:07 -0400, Alvaro Herrera wrote:
> Tom Lane wrote:
> > Michael Gould 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 ot
Tom Lane wrote:
> Michael Gould 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 it late
Michael Gould 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 it later...
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
904.226.0978
11 matches
Mail list logo
