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