Tatsuo Ishii <ishii@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general