Re: postgres_fdw error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: postgres_fdw error
Дата
Msg-id 13868.1439588329@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: postgres_fdw error  (Adam FUCHS <atman@berkeley.edu>)
Ответы Re: postgres_fdw error  (Adam FUCHS <atman@berkeley.edu>)
Список pgsql-admin
Adam FUCHS <atman@berkeley.edu> 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Adam FUCHS
Дата:
Сообщение: Re: postgres_fdw error
Следующее
От: Adam FUCHS
Дата:
Сообщение: Re: postgres_fdw error