Re: unlock / drop table

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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110