Re: replicating DDL statements

On Thursday March 6 2003 11:33, Ed L. wrote:
> 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?

And in the absence of a SET TRIGGERS='off' command, anyone see any concerns
with the following?

  UPDATE pg_trigger
  SET tgenabled = 'f'
  WHERE tgname LIKE '%whatever%';

Ed