Re: Errors when restoring backup created by pg_dumpall

On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston <david.g.johnston@gmail.com>
wrote:

> On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@gmail.com>
> wrote:
>
>> Another alternative is to open the .sql file in Notepad++, then add
>> "public." before all the unqualified "earth" and "ll_to_earth" references.
>>
>
> And as discussed there are none in that file because those references are
> within an extension's objects and only create extension appears in the file.
>

Then why would changing search_path work?

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!