Re: RFC: listing lock status - Mailing list pgsql-hackers

From nconway@klamath.dyndns.org (Neil Conway)
Subject Re: RFC: listing lock status
Date
Msg-id 20020718233704.GA16810@klamath.dyndns.org
Whole thread Raw
In response to Re: RFC: listing lock status  (Joe Conway <mail@joeconway.com>)
Responses Re: RFC: listing lock status  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, Jul 18, 2002 at 03:12:53PM -0700, Joe Conway wrote:
> Neil Conway wrote:
> > Also, should locks on special relations (e.g. pg_xactlock) or on
> > system catalogs be shown?
> 
> Maybe the function should take a boolean parameter to indicate whether
> or not to show locks on objects in pg_* schema?

I had thought about that, but it occurs to me that the DBA can
effectively choose this for himself using the relID and databaseID
returned by the SRF, in combination with pg_database.datlastsysoid.

Cheers,

Neil

-- 
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: preventing encoding conversion while starting up
Next
From: Tatsuo Ishii
Date:
Subject: Re: preventing encoding conversion while starting up