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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general