Re: FWD: Re: Updated backslash consistency patch
| От | Stephen Frost |
|---|---|
| Тема | Re: FWD: Re: Updated backslash consistency patch |
| Дата | |
| Msg-id | 20090116035022.GV4656@tamriel.snowman.net обсуждение |
| Ответ на | Re: FWD: Re: Updated backslash consistency patch (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-hackers |
* 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
В списке pgsql-hackers по дате отправления: