On Saturday, November 30, 2024, PopeRigby <poperi...@mailbox.org> wrote:

>
> Ok, so the error is not emanating from your code but rather the body of
> the ll_to_earth function defined in the earthdistance extension.
>
> David J.
>
> By code do you mean my sql file created by pg_dumpall? Sorry, I'm just a
> self-hoster so I'm not very well versed in Postgres. I'm just trying to get
> my server back online.
>

Yes, your “code” is the user contents of the SQL file.

Your best bet is probably to locate the various “set_config(‘search_path’,
‘’)” commands and add “public” to them.  Since you installed earthdistance
to public this should bridge the gap.

David J.

Reply via email to