Stephen Frost <sfr...@snowman.net> writes: > Regardless of what I reset my search_path to, I'm going to have access > to abstime. Is there something else special about it besides being > a 'system function' and being in pg_catalog to make it always available > regardless of my search_path?
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. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers