Skip site navigation (1) Skip section navigation (2)

Re: unlock / drop table

From: Neil Conway <neilc(at)samurai(dot)com>
To: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: unlock / drop table
Date: 2002-09-26 21:44:06
Message-ID: 87hegczas9.fsf@mailbox.samurai.com (view raw or flat)
Thread:
Lists: pgsql-general
"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)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(at)samurai(dot)com> || PGP Key ID: DB3C29FC


In response to

pgsql-general by date

Next:From: Rod TaylorDate: 2002-09-26 21:45:23
Subject: Re: [GENERAL] Performance while loading data and indexing
Previous:From: Bruce MomjianDate: 2002-09-26 21:41:22
Subject: Re: [HACKERS] Performance while loading data and indexing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group