* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Read the documentation for search_path: if pg_catalog isn't explicitly
> mentioned, we add it implicitly. This is mainly because it would be
> contrary to SQL spec (and pretty useless to boot) to not recognize the
> standard functions and operators. But beyond that hack, there is no
> mechanism other than search_path that determines what's visible or not.
Sorry, I didn't mean to imply I was completely oblivious to this. I
think I spoke a little too quickly and phrased it poorly.
It would be nice for an administrator to be able to implicitly add other
schemas to the search_path, primairly for functions but possibly other
things, because that way add-on modules like PostGIS could look more
like they're just part of PG. Another option might be to add things to
pg_catalog, but I suspect that's frowned upon with good reason.
Thanks,
Stephen