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

pgAdmin III: system schemas under incorrect hiearchy in EDBAS PostgreSQL mode

From: Nikhil S <nixmisc(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgAdmin III: system schemas under incorrect hiearchy in EDBAS PostgreSQL mode
Date: 2011-02-25 15:05:51
Message-ID: AANLkTin+srk60JL1CMiTQfW1eY21GUM0gqVpmj8Ny3w5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
Hi,

If we use pgadmin III to browse a PPAS database that was installed in
Postgresql mode, the "sys" and "dbo" system schemas appear incorrectly under
the normal user "Schemas" hierarchy. The issue is occurring because the
current sql in pgSchemaBaseFactory::CreateObjects() which tries to avoid
showing non-system schemas is incorrect.

Since these schemas are added at initdb time, IMO just checking for these
schemas by name should be enough. This patch does just the same.

Regards,
Nikhils

Attachment: pgadmin3_pg_mode_sysdbo_schemas.patch
Description: text/x-diff (1.4 KB)

Responses

pgadmin-hackers by date

Next:From: Peter GeogheganDate: 2011-02-25 20:31:14
Subject: wxWidgets 2.9 compatibility: Fix for sefault on table editor under GTK
Previous:From: Guillaume LelargeDate: 2011-02-24 23:48:38
Subject: Re: pgAdmin and pg_service.conf

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