niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » PostgreSQL
databases hidden in phppgadmin
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
Robert Treat
*nix forums addict


Joined: 14 Mar 2005
Posts: 93

PostPosted: Tue Jul 18, 2006 7:12 pm    Post subject: Re: databases hidden in phppgadmin Reply with quote
On Friday 14 July 2006 11:22, Tom Lane wrote:
Quote:
"Darren" <notross@hotmail.com> writes:
When I login to phppgadmin, the list of databases does not include any
databases that are owned by a 'group' (i.e. a role with NOLOGIN set).

I'm betting that phppgadmin is using something like an inner join of
pg_database and pg_user to produce its display. As of PG 8.1 they need
to be using pg_roles instead ... and if I were them, I'd make it a LEFT
JOIN so that databases don't disappear completely if the owner can't be
found.

You know Tom, if you're interested in hacking on phpPgAdmin, I'd be happy to
send you a copy of "Beginning PHP & PostgreSQL 8 "
:-)

Darren, this is fixed in ppa's CVS HEAD. If you want a specific patch, drop
me a note off list, though I am thinking of putting out a 4.0.2 release
sometime this week.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq
Back to top
Tom Lane
*nix forums Guru


Joined: 24 Mar 2005
Posts: 2070

PostPosted: Fri Jul 14, 2006 3:22 pm    Post subject: Re: databases hidden in phppgadmin Reply with quote
"Darren" <notross@hotmail.com> writes:
Quote:
When I login to phppgadmin, the list of databases does not include any
databases that are owned by a 'group' (i.e. a role with NOLOGIN set).

I'm betting that phppgadmin is using something like an inner join of
pg_database and pg_user to produce its display. As of PG 8.1 they need
to be using pg_roles instead ... and if I were them, I'd make it a LEFT
JOIN so that databases don't disappear completely if the owner can't be
found.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org
Back to top
Darren
*nix forums addict


Joined: 01 Mar 2005
Posts: 84

PostPosted: Thu Jul 13, 2006 7:44 pm    Post subject: databases hidden in phppgadmin Reply with quote
My apologies if this is not the correct group, but I did not find a
'phppgadmin' specific group.

When I login to phppgadmin, the list of databases does not include any
databases that are owned by a 'group' (i.e. a role with NOLOGIN set).
Databases owned by postgres or any specific user do show up. I have
tried logging in as superuser, as well as a user belonging to the said
group, but the databases do not show up.

Is there a config option I need to set to allow this, or is it simply
not possible.

Thanks!
--Darren Hromas


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Fri Nov 21, 2008 11:57 am | All times are GMT
navigation Forum index » Databases » PostgreSQL
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts database Share Memory Limit (2 GB ) in a Instance is tota... sadanjan@gmail.com IBM DB2 0 Fri Jul 21, 2006 12:57 pm
No new posts Linking Tables from 2 databases Pratik Shukla PostgreSQL 2 Wed Jul 19, 2006 5:54 pm
No new posts checking against spam databases Ignacio Garcia Postfix 2 Fri Jul 14, 2006 10:12 am
No new posts Allow user to create databases, but limit all privileges ... Isaac Davis-King MySQL 1 Wed Jul 12, 2006 6:49 pm
No new posts Allow user to create databases, but limit all privileges ... Isaac Davis-King MySQL 0 Wed Jul 12, 2006 4:50 pm

Free phpBB forum | Books | Repair Bad Credit | McDonalds | Bad Credit Mortgages
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.1364s ][ Queries: 20 (0.0632s) ][ GZIP on - Debug on ]