On Thu, Sep 26, 2002 at 12:41:15PM -0400, Johnson, Shaunn wrote:
> How can I:
>
> a) find out who is locking the table (other than Postgres)
You can find out the queris that are locking the table by using ps or
pg_monitor or something like that. Once you have the pid, if you use
connection tracking in your logs, you can look in the logs for the
connection.
> b) should I kill the pid of the LOCK so the table
> can continue it course or will that hurt something else
> (particularly the database)?
kill -2 should be safe.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110