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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2008-01-30 15:55:31 | Re: Feature request - Decode relation in Server Status / Lock display |
Previous Message | Guillaume Lelarge | 2008-01-30 14:30:51 | Re: Feature request - Decode relation in Server Status / Lock display |