From: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: Schema bug |
Date: | 2005-12-09 01:14:50 |
Message-ID: | 4398DA8A.5080608@phlo.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Dave Page wrote:
>>Andreas Pflug wrote:
>>>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.
>>
>>This argument scares me... I believe a GUI-Tool shouldn't impose any
>>additional restrictions to what you can do with your database -
>>otherwise GUI-Users become second-class citzicens when
>>compared to those
>>who use the commandline/psql. Why exactly does pgadmin depend on
>>the existance of the public schema?
>
> The first thing that springs to mind is that we can only tell that it is
> *not* a system schema from it's name. The normal test (oid <
> LAST_SYSTEM_OID) doesn't work because it's created during (in
> template1/template0 at least).
Hm.. couldn't it check the system-schemas by name instead - so, saying
"it's a non-system schema if it isn't called information_schema or
pg_catalog", instead of "it's a system-schema if oid < LAST_SYSTEM_OID
and name is not public"? Or are there other system schemas I don't know
of (quite possible ;-) )?
greetings, Florian Pflug
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-12-09 08:21:08 | Re: Schema bug |
Previous Message | Peter Eisentraut | 2005-12-08 23:04:26 | Default encoding for new databases |