Re: replicating DDL statements

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: "Gregory Wood" <gregw(at)com-stock(dot)com>, "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: replicating DDL statements
Date: 2003-03-06 18:33:09
Message-ID: 200303061133.09355.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday March 6 2003 11:25, Gregory Wood wrote:
> > I considered setting up triggers on Pgsql system tables to replicate
> > DDL statements and replicate those system row changes much like user
> > data, and to also use system table triggers to create replication
> > triggers for newly added tables. But user triggers are not allowed on
> > system tables, and I'm not sure it'd be reasonable or wise anyway.
> > Comments or other ideas?
>
> One potential problem you might run into is triggers on said added
> tables.
>
> I had to disable my user-made triggers on slave databases because ...

Anyone know if there a way to disable triggers for the current transaction?
Much like the "SET CONSTRAINTS ALL DEFERRED"? Is that doable?

Ed

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emmanuel Charpentier 2003-03-06 18:54:54 [OT] : mailing list - news server gateway out of commission ?
Previous Message Gregory Wood 2003-03-06 18:25:49 Re: replicating DDL statements