* Tom Lane (t...@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
signature.asc
Description: Digital signature
