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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
