Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> "Sergei" == Sergei Kornilov <sk@zsrv.org> writes:
> Sergei> I think we can fix this issue by marking SQL language functions
> Sergei> "set search_path from current".
> Unfortunately using SET on sql-language functions prevents inlining.
Yeah. Another problem is that SET FROM CURRENT will freeze the
search_path at the current setting, which means it'll likely
fail again if either extension in question gets relocated.
Even if this were a perfect solution, it only fixes things for
earthdistance, whereas the same problem exists for any extension
containing SQL or PL functions. So I wish we had a more general
answer ... not that I know what that should look like.
regards, tom lane