Postgres Pro
Downloads
Home   >   mailing lists

unlock / drop table - Mailing list pgsql-general

From Johnson, Shaunn
Subject unlock / drop table
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB04C73FC0@snt452.corp.bcbsm.com
Whole thread Raw
Responses Re: unlock / drop table  (Andrew Sullivan <andrew@libertyrms.info>)
Re: unlock / drop table  (Neil Conway <neilc@samurai.com>)
List pgsql-general
Tree view

Howdy:

Running PostgreSQL 7.2.1 on RedHat Linux 7.2 kernel 2.4.7-10.

I got a few people trying to drop tables; right now,
there is a lock on them and I want to kill that person's
lock and have the table dropped.

How can I:

a) find out who is locking the table (other than Postgres)

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)?

Thanks!

-X

pgsql-general by date:

Previous
From: "Grégory Luguet"
Date:
Subject: can Trigger be as real "standalone" program?
Next
From: Bruce Momjian
Date:
Subject: Re: Performance while loading data and indexing