Re: replicating DDL statements - Mailing list pgsql-general

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?

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110