Information regarding currently locked tables

From: Nirmalya Lahiri <nirmalyalahiri(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Information regarding currently locked tables
Date: 2006-10-18 09:22:14
Message-ID: 20061018092214.45137.qmail@web30310.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
I want a list of currently locked tables. How can I do that? I already found a list from pg_locks table. But how I know the name of the table against relation id of a relation?

Nirmalya Lahiri
(+91-94331-13536)

---------------------------------
Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business.

Browse pgsql-general by date

  From Date Subject
Next Message Gregory S. Williamson 2006-10-18 10:16:52 Re: Maximum size of database
Previous Message Ilja Golshtein 2006-10-18 08:56:10 Re: COPY FROM STDIN instead of INSERT