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