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

Re: Feature request - Decode relation in Server Status / Lock display

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Mike Blackwell <maiku41(at)sbcglobal(dot)net>, pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Feature request - Decode relation in Server Status / Lock display
Date: 2008-01-30 15:24:05
Message-ID: 47A09695.9040809@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-support
Mike Blackwell wrote:
> Guillaume Lelarge wrote:
>> Mike Blackwell wrote:
>>> Would it be possible, perhaps as an option, to display the relation 
>>> name, and possibly the type, in the Server Status Lock display?
>>>
>>
>> It already does this but you only have relation names for relations 
>> belonging to the database you're connected to (ie your maintenance 
>> database).
>>
>>
> Hmm...
> 
> Connected to via the initial connection as listed in the server 
> registrartion window?

Yes, this is the maintenance database.

>  Or connected to by selecting it in the Object 
> browser so it no longer has on X on the icon, or the currently selected 
> database in the browser?

No.

> I generally have connections (as shown on the 
> Server Status page) to several database, including the one I expect to 
> have the locks in question, but do not see the relations translated.
> What prevents showing the names for all databases?

It's a PostgreSQL security feature. When you're connected to a database, 
tables from other databases are not available (even their names).

   It's curious that
> the oids are available but not the names.  I should really brush off my 
> C skills and take a look at the code sometime to see what's going on in 
> there. ^_^'''

:)


-- 
Guillaume.
  http://www.postgresqlfr.org
  http://dalibo.com

In response to

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2008-01-30 15:55:31
Subject: Re: Feature request - Decode relation in Server Status / Lock display
Previous:From: Guillaume LelargeDate: 2008-01-30 14:30:51
Subject: Re: Feature request - Decode relation in Server Status / Lock display

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