disable/enable trigger hangs

From: Mike Charnoky <noky(at)nextbus(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: disable/enable trigger hangs
Date: 2007-03-28 15:58:21
Message-ID: 460A909D.3070202@nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I'm using PostgreSQL 8.1.4 and am having some problems with the new
disable/enable trigger command.

First, a question: For a PG8.1 database, is it preferable to use the new
"alter table disable|enable trigger" command as opposed to the old
method of setting pg_class.reltriggers = 0?

I'm assuming the "alter table" approach is preferred, so I converted
some scripts to use the new method. However, sometimes the
enable/disable trigger command hangs when operating on certain tables.
I use the syntax "ALTER TABLE mytable DISABLE TRIGGER ALL;". Any hints
on how to debug this?

Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2007-03-28 16:07:53 Re: redhat debug info
Previous Message Tom Lane 2007-03-28 15:56:41 Re: unexpected data beyond EOF and character encoding