Thanks for the quick reply Tom! The pg_locks table helped me to get to
the bottom of this.
For future reference to others, here is a good way to view the pg_locks
table for a particular database, adding table name annotation:
SELECT pg_locks.*, pg_class.relname from pg_locks, pg_class
WHERE pg
Mike Charnoky <[EMAIL PROTECTED]> writes:
> 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?
Very much so --- manual manipulation of reltriggers has never been
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 assum
