2005/12/7, Andreas Pflug <pgadmin(at)pse-consulting(dot)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
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
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
In response to
pgadmin-hackers by date
|Next:||From: svn||Date: 2005-12-07 11:04:31|
|Subject: SVN Commit by andreas: r4805 - trunk/pgadmin3/i18n/ca_ES|
|Previous:||From: Andreas Pflug||Date: 2005-12-07 00:07:46|
|Subject: Re: Schema bug|