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

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