Feedback-ID: i76984098:Fastmail
Message-ID: <09e17634-f0a7-4fd6-9901-f76daf8654a7@aklaver.com>
Date: Thu, 5 Dec 2024 19:48:37 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Errors when restoring backup created by pg_dumpall
To: Ron Johnson <ronljohnsonjr@gmail.com>,
 pgsql-general <pgsql-general@postgresql.org>
References: <6a6439f1-8039-44e2-8fb9-59028f7f2014@mailbox.org>
 <cba48d2c-0987-4233-a86f-2e693677efd3@aklaver.com>
 <9c5ba566-27b8-4e8c-bf7d-2dc561509991@mailbox.org>
 <CAKFQuwaB5GuUNuyiUbS0ah-LYXepHLPnOHrP7g8RMz8ywOm3zQ@mail.gmail.com>
 <ff94f628-27af-4c3a-9590-cba38bb5d2d1@mailbox.org>
 <CAKFQuwYQUequkYVS8SLgC1L0TOdWNK=xVyxnPD9RPPwfvYRFSQ@mail.gmail.com>
 <41791b6d-aaf5-4fed-9cc3-e89bc49e8637@mailbox.org>
 <CAKFQuwbe4TSU_LxsrGxgcv4DfQq2x-UNoyKx-ABy36PhvbGCdg@mail.gmail.com>
 <1257068.1733025493@sss.pgh.pa.us>
 <06425038-e012-4bac-aec1-d9541436f893@mailbox.org>
 <92405f98-7f0c-4442-8252-697352daefc1@aklaver.com>
 <1470486.1733087658@sss.pgh.pa.us>
 <4ab662d8-57cc-471f-8a58-cfd71d1cea22@aklaver.com>
 <1475512.1733090108@sss.pgh.pa.us>
 <19d5f2c7-1252-4442-accb-8aa2cb289ad0@mailbox.org>
 <CANzqJaCAtmhvXfE-5--Pzk4Wr=9q+C=d8jiVj-Zm=aNnZMCwNg@mail.gmail.com>
 <CAKFQuwaXsgZncO10khobrdC=_NLxBWQX4XQEuVVCfouqqrnLHA@mail.gmail.com>
 <CANzqJaA1VV6gzoBTLAwUcm5cOzNPhtKUVfvxpa66BttP1EgPqg@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CANzqJaA1VV6gzoBTLAwUcm5cOzNPhtKUVfvxpa66BttP1EgPqg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/09e17634-f0a7-4fd6-9901-f76daf8654a7%40aklaver.com>
Precedence: bulk

On 12/5/24 18:44, Ron Johnson wrote:
> On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston 
> <david.g.johnston@gmail.com <mailto:david.g.johnston@gmail.com>> wrote:
> 
>     On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@gmail.com
>     <mailto: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?

Because that is set for each database before the objects in that 
database are created. That means anything that is created subsequently 
will be have access to all other objects created in the path. This would 
include objects created indirectly from an extension as well as objects 
that include non-schema qualified names.

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

-- 
Adrian Klaver
adrian.klaver@aklaver.com