Re: BUG #15530: unable restore index on function from earthdistance contrib

Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
> "Sergei" == Sergei Kornilov <sk(at)zsrv(dot)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