Re: Schema bug - Mailing list pgadmin-hackers

From Guillaume Lelarge
Subject Re: Schema bug
Date
Msg-id d854adec0512062331o4f3fd35eu@mail.gmail.com
Whole thread Raw
In response to Re: Schema bug  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgadmin-hackers
2005/12/7, Andreas Pflug <pgadmin@pse-consulting.de>:
> Guillaume LELARGE wrote:
> > Hi,
> >
> > I found a weird bug today. If you rename the public schema, it becomes
> > unavailable. Here is a patch to fix it. It modifies the query to use the oid
> > instead of the schema's name. Works great on Linux, should'nt be a problem on
> > win32.
>
> Actually, to me renaming the public schema appears as the primary bug...
> There are many ways to corrupt pgAdmin's behaviour, and you found one of
> 'em. Renaming public is so irregular, I doubt it's worth changing the
> behaviour.
>

If you're right, pgAdmin should not allow to change the public schema's name.

It's really dangerous if renamming/dropping the public shema's name
can corrupt pgAdmin's behavior. PostgreSQL's documentation says :
There is nothing special about the public schema except that it exists
by default. It can be dropped, too. (see
http://www.postgresql.org/docs/8.1/interactive/ddl-schemas.html#DDL-SCHEMAS-PATH)

It even says that : Also, there is no concept of a public schema in
the SQL standard. For maximum conformance to the standard, you should
not use (perhaps even remove) the public schema. (see
http://www.postgresql.org/docs/8.1/interactive/ddl-schemas.html#DDL-SCHEMAS-PORTABILITY)

Regards.


--
Guillaume.

pgadmin-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Schema bug
Next
From: svn@pgadmin.org
Date:
Subject: SVN Commit by andreas: r4805 - trunk/pgadmin3/i18n/ca_ES