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>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Feature request - Decode relation in Server Status / Lock display
Date: 2008-01-30 15:55:31
Message-ID: 47A09DF3.10808@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-support
Mike Blackwell wrote:
> Guillaume Lelarge wrote:
>> 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. ^_^'''
>>
>> :)
>>
>>
> 
> Ah.  I see.  So to display the names, we'd have to connect to each 
> database in turn and look for a name that matched the oid, right?  Might 
> be worth it, as that's what I end up having to do manually, anyway. ^_^
> 
> 

Something that would be interesting to do is to add a combobox to 
quickly change the database used for connection (something like the 
connection combo box in the query tool).


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

In response to

pgadmin-support by date

Next:From: Thomas H.Date: 2008-01-31 12:43:58
Subject: Re: bug: the schema oid can't be located, please refresh all schemas
Previous:From: Guillaume LelargeDate: 2008-01-30 15:24:05
Subject: Re: Feature request - Decode relation in Server Status / Lock display

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