Adam FUCHS <atman@xxxxxxxxxxxx> writes: > Thanks Korry, how would I check the search_path that is being used by the > FDW user? postgres_fdw always does "SET search_path = pg_catalog" when opening the connection. Probably this needs to be documented, since it's user-visible if you try to attach a foreign table to a remote view. Anyway the short answer is that you should fully schema-qualify references in functions used by such a view, or else attach "SET search_path" options to the functions. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
