public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Errors when restoring backup created by pg_dumpall
Date: Thu, 5 Dec 2024 19:48:37 -0800
Message-ID: <[email protected]> (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 12/5/24 18:44, Ron Johnson wrote:
> On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston
> <[email protected] <mailto:[email protected]>> wrote:
>
> On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson <[email protected]
> <mailto:[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 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
[email protected]
view thread (5+ messages) latest in thread
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: <[email protected]>
* 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