Обсуждение: postgres_fdw changes schema search path

I'm just wondering why postgres_fdw explicitly sets search_path to
pg_catalog. If it does not do that, is there any security risk?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

Tatsuo Ishii <ishii@postgresql.org> writes:
> I'm just wondering why postgres_fdw explicitly sets search_path to
> pg_catalog. If it does not do that, is there any security risk?

There was a long discussion of that back in February or so, when the
patch was (about to be) committed.  In general, if this is causing you
problems, it probably means you're doing something that's not very safe
anyway.

            regards, tom lane