Re: replicating DDL statements

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: replicating DDL statements
Date: 2003-03-06 22:36:42
Message-ID: 20030306173642.Y27304@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tanu Shankar Bhatnagar 2003-03-06 22:52:01 designer tool for pgsql
Previous Message Thomas T. Thai 2003-03-06 22:13:27 Tom Lane - Your email filters are blocking everything