Search Postgresql Archives

Information regarding currently locked tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Information regarding currently locked tables
From: Nirmalya Lahiri <nirmalyalahiri@xxxxxxxxx>
Date: Wed, 18 Oct 2006 02:22:14 -0700 (PDT)
Reply-to: nirmalyalahiri@xxxxxxxxx

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Prev by Date: Re: COPY FROM STDIN instead of INSERT
Next by Date: Re: Maximum size of database
Previous by thread: Moving postgres users accounts from one postgres 7.3 to postgres 8.0
Next by thread: increasing LIMIT with ORDER BY changes queryplan (7.4)
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux