Lonni J Friedman <netllama(at)gmail(dot)com> writes:
> Thanks for your reply. This sounds like a relatively simple
> workaround, so I'll give it a try. Is the search_path of the remote
> session that postgres_fdw forces considered to be intentional,
> expected behavior, or is it a bug?
It's intentional.
Possibly more to the point, don't you think your trigger function is
rather fragile if it assumes the caller has provided a particular
search path setting?
regards, tom lane