Re: replicating DDL statements

On Thursday March 6 2003 3:36, Andrew Sullivan wrote:
> On Thu, Mar 06, 2003 at 02:45:41PM -0700, Ed L. wrote:
> > 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%';
>
> I have heard warnings that this is not guaranteed to work, as there
> may still be places in the code where checking that table is not
> happening.  Perhaps that was only true for older versions, though?

Unfortunately not.  It doesn't work for me on 7.3.2 with a triggered C
function (dbmirror). :(

Ed