Le Vendredi 09 Décembre 2005 09:21, Dave Page a écrit :
> > -----Original Message-----
> > From: Florian G. Pflug [mailto:fgp(at)phlo(dot)org]
> > Sent: 09 December 2005 01:15
> > To: Dave Page
> > Cc: Andreas Pflug; pgadmin-hackers
> > Subject: Re: [pgadmin-hackers] Schema bug
> > 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 ;-) )?
> Probably - but it's more of a future-proofing kinda thing. Pretty weak
> argument though...
I had two ways to fix this bug : detect system schemas on their names, or
detect public schema by its OID. I think it's better to only keep the public
schema with its OID, it's much less risky to have a wrong one. That's what
the patch is doing :
AND nspname != 'public'
is replaced by
AND nsp.oid != 2200
I still think this patch should be applied.
In response to
pgadmin-hackers by date
|Next:||From: Dave Page||Date: 2005-12-10 00:22:32|
|Subject: Re: Schema bug|
|Previous:||From: Andreas Pflug||Date: 2005-12-09 22:28:44|
|Subject: Re: i18n files|