Le Mardi 13 Décembre 2005 00:48, Guillaume LELARGE a écrit :
> Le Samedi 10 Décembre 2005 16:55, Andreas Pflug a écrit :
> > Dave Page wrote:
> > >>I still think this patch should be applied.
> > >
> > > Does anyone see a reason /not/ to do this?
> >
> > Hm, Guillaume started a thread on pgsql-hackers about renaming system
> > schemas in general, maybe we should wait for the result of that
> > discussion.
>
> Well, it seems that pg_* schemas are system schemas and that public and
> information_schema schemas are public one. I think we should exclude system
> schemas depending on their names and show public and information_schema,
> whatever their actual name are.
>
> I can bring a new patch if you agree with this and if you find this useful.
What about this one ?
--
Guillaume.
<!-- http://abs.traduc.org/
http://lfs.traduc.org/
http://traduc.postgresqlfr.org/ -->
Index: pgSchema.cpp
===================================================================
--- pgSchema.cpp (révision 4843)
+++ pgSchema.cpp (copie de travail)
@@ -163,8 +163,7 @@
pgSet *schemas = collection->GetDatabase()->ExecuteSet(
wxT("SELECT CASE WHEN nspname LIKE 'pg\\_temp\\_%%' THEN 1\n")
- wxT(" WHEN (nsp.oid<") + NumToStr(collection->GetServer()->GetLastSystemOID()) +
- wxT(" OR nspname like 'pg\\_%') AND nspname != 'public' THEN 0\n")
+ wxT(" WHEN nspname LIKE 'pg\\_%' THEN 0\n")
wxT(" ELSE 3 END AS nsptyp,\n")
wxT(" nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner, nspacl, description,")
wxT(" has_schema_privilege(nsp.oid, 'CREATE') as cancreate\n")
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
