Обсуждение: pgAdmin III: system schemas under incorrect hiearchy in EDBAS PostgreSQL mode
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
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
Вложения
Thanks - applied (with a minor tweak to make it work) :-p On Fri, Feb 25, 2011 at 3:05 PM, Nikhil S <nixmisc@gmail.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@postgresql.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
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@gmail.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@postgresql.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