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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110