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

From: Nikhil S <nixmisc(at)gmail(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: pgAdmin III: system schemas under incorrect hiearchy in EDBAS PostgreSQL mode
Date: 2011-02-28 13:49:51
Message-ID: AANLkTiniTtm3dJJi4NbL7PiN16bS5fDBRMAOxhnYpcf7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

> Thanks - applied (with a minor tweak to make it work) :-p
>
>
Heh, thanks Dave :)

Regards,
Nikhils

> On Fri, Feb 25, 2011 at 3:05 PM, Nikhil S <nixmisc(at)gmail(dot)com> wrote:
> > 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
> >
> >
> > --
> > Sent via pgadmin-hackers mailing list (pgadmin-hackers(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgadmin-hackers
> >
> >
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2011-02-28 23:41:41 Updated OGL licence
Previous Message Dave Page 2011-02-28 13:36:57 Re: pgAdmin III: system schemas under incorrect hiearchy in EDBAS PostgreSQL mode