Dave Page wrote:
>>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.
> Does anyone see a reason /not/ to do this?
I'd prefer system-catalogs being excluded by name - preferably the
exclusion-list would be editable, and part of the pgadmin preferences.
Seems more transparent to me - and future-proof, in the sense that
even if a future postgres version chooses to rename some catalog, the
user will be able to just add the new names to the exclusion list.
greetings, Florian Pflug
In response to
pgadmin-hackers by date
|Next:||From: Andreas Pflug||Date: 2005-12-12 23:00:58|
|Subject: Re: Schema bug|
|Previous:||From: svn||Date: 2005-12-12 11:37:05|
|Subject: SVN Commit by andreas: r4841 - branches/REL-1_4_0_PATCHES/pgadmin3/src/slony|