Kevin Grittner <kgri...@ymail.com> wrote: > Marti Raudsepp <ma...@juffo.org> wrote:
>> What are the interactions with search_path? > > Pretty much the same as the interactions of RTEs with search_path. > If the apparent relation name is not schema-qualified, parse > analysis first tries to resolve the name as an RTE, and if that > fails it tries to resolve it as a named tuplestore, and if that > fails it goes to the catalogs using search_path. Argh. s/RTE/CTE/ -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers