public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Ron Johnson <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Errors when restoring backup created by pg_dumpall
Date: Thu, 5 Dec 2024 22:06:42 -0700
Message-ID: <CAKFQuwZD80Na1sOmibDFzSBx=6OeySuoDZFbytcinxNP+2OtMw@mail.gmail.com> (raw)
In-Reply-To: <CANzqJaA1VV6gzoBTLAwUcm5cOzNPhtKUVfvxpa66BttP1EgPqg@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<[email protected]>
<CAKFQuwaB5GuUNuyiUbS0ah-LYXepHLPnOHrP7g8RMz8ywOm3zQ@mail.gmail.com>
<[email protected]>
<CAKFQuwYQUequkYVS8SLgC1L0TOdWNK=xVyxnPD9RPPwfvYRFSQ@mail.gmail.com>
<[email protected]>
<CAKFQuwbe4TSU_LxsrGxgcv4DfQq2x-UNoyKx-ABy36PhvbGCdg@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<CANzqJaCAtmhvXfE-5--Pzk4Wr=9q+C=d8jiVj-Zm=aNnZMCwNg@mail.gmail.com>
<CAKFQuwaXsgZncO10khobrdC=_NLxBWQX4XQEuVVCfouqqrnLHA@mail.gmail.com>
<CANzqJaA1VV6gzoBTLAwUcm5cOzNPhtKUVfvxpa66BttP1EgPqg@mail.gmail.com>
On Thursday, December 5, 2024, Ron Johnson <[email protected]> wrote:
> On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston <
> [email protected]> wrote:
>
>> On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson <[email protected]>
>> 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 (I presume) function inlining during execution of create table
keeps the search_path of the session executing create table which will then
result in the parser resolving the unqualified “earth” function name to the
one existing in the public schema when looking through the session’s
search_path.
David J.
view thread (5+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Errors when restoring backup created by pg_dumpall
In-Reply-To: <CAKFQuwZD80Na1sOmibDFzSBx=6OeySuoDZFbytcinxNP+2OtMw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox