Re: postgres_fdw changes schema search path

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