Re: [pgadmin-support] altering the name of the public schema [SOLVED]

[Jochem van Dieten]

Dave Page wrote:

From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]

Could it be that somewhere in pgAdminII there is a reference to the OID 2200 that is assigned to the public schema by default?

pgAdmin hides system objects by default, but in the case of the public
schema it makes an exception bcause hiding public would not be sensible.
It does it by a combination of name and OID: the oid is less than the
last system oid, so it is hidden, except if it is called public.

Switch on show System Objects on the view menu and you should see it.

That indeed solves this issue. May I make an enhancement request that objects with an OID less than the last system OID are hidden, unless the OID is 2200 (system OID's are not cycled, are they)?

Jochem


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

http://www.postgresql.org/users-lounge/docs/faq.html