Postgres Pro
Downloads
Home   >   mailing lists

Re: unlock / drop table - Mailing list pgsql-general

From Neil Conway
Subject Re: unlock / drop table
Date
Msg-id 87hegczas9.fsf@mailbox.samurai.com
Whole thread Raw
In response to unlock / drop table  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general
Tree view 
"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> a) find out who is locking the table (other than Postgres)

7.3 has a pg_locks system view that should be useful for this.

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Performance while loading data and indexing
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Performance while loading data and indexing