Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tJOKP-002hjS-Al for pgsql-general@arkaria.postgresql.org; Fri, 06 Dec 2024 02:44:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tJOKM-009bT2-Gh for pgsql-general@arkaria.postgresql.org; Fri, 06 Dec 2024 02:44:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tJOKM-009bSs-5T for pgsql-general@lists.postgresql.org; Fri, 06 Dec 2024 02:44:23 +0000 Received: from mail-oo1-xc33.google.com ([2607:f8b0:4864:20::c33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tJOKK-001HpF-GF for pgsql-general@postgresql.org; Fri, 06 Dec 2024 02:44:22 +0000 Received: by mail-oo1-xc33.google.com with SMTP id 006d021491bc7-5f205c4625dso452020eaf.3 for ; Thu, 05 Dec 2024 18:44:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1733453058; x=1734057858; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=rS6kaEl2j0l19swVUH9Yc0YFPl9AuAnhgXN851B8Ln4=; b=I0Sp6wMbSlMTkgqMO9ZlPTuqxkX+LB7AXU5PjsDaSvTtEH5H1zLye+mtvVWuOYtKnp OIxYx/aJG/7jCgoCEt9tw8k5xa7Dl+K8cBW7g24Ez2uFpdvkzz19sQUQLXuXNj16tmeP lGEdgYS1zg9nrHQjFuFuGxOpSzOFqw0KxP1dYsFPGUmW7NL7Vq1x9ve6zRlMp75TjaHX qxmJdquItgP9vPN403LHlwrRdv9OyOwA0ZPHQOpnMNazLNCwvj+Ko9FXWGF6+blrq9a9 qvHYqpu/Ub/wkfVnuQ3vZCNaf5SwAO/Po6UInGxHea7ZYNvBHXhH8XNlCtQ+LRKPo8Tr 70hg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1733453058; x=1734057858; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=rS6kaEl2j0l19swVUH9Yc0YFPl9AuAnhgXN851B8Ln4=; b=LUB+aZxiweysAoT8/08k/4sujeBVJSwQnL/UqVNDuDN/eWk6AN0x4imfnFmZ/DLt8j q/jD4IXJ+2VXJpMZz+TNktNCRVBJD1ANk+EyXT07yfkl95iI8uAS3Uh+uGrBGDN6+Tdm XkmOUDkb0u0IYlyGRyHZjEyatbjYjjfOqNhHCt0snTUdWzjAuJm5a+29jrnjIz2offt6 hX5FudUDNKAgzKzQm0Z8LMrRST+lu19YWtMBkhFb2TYtQBG3c6yO4cECISVkTv9Vs5ge U08XaBdPeGvreuarW5yVuFu6QOA8dfPMNykjcTny7p/A6k2liPgHewzNmn3iKKbruIai U7cQ== X-Gm-Message-State: AOJu0Yxo4yg+yA5v+JJMPyYg5eCGr3yPP+8JZN92Yjn3WwdFfhSXabCG IH+psRUGNdYnWls87IyXYjtR9l0+lapL0rWR0SGZvW0TY/qiPKYTaj6WBjAMBVdsJc8fIgxzExR rwHlHOAybJ4eZLzw/A2xqjcTuxnmQYQ== X-Gm-Gg: ASbGncsmiJNIyyjBTx0su0PSQ/Jl6jY36f1IJZVrmw2TfWc000jZP5pxFOQxiWCm+n5 EaMPXGNg3vA7bk/PsttfnewnZT5YUhtoBIv3CC+NGmGMOGcPziphPlk6E8raFufJLSw== X-Google-Smtp-Source: AGHT+IFAJVQA0XhvJ3bVrBbeCI7vdXTBqJeTBkAtd3Lg48bxIC5boVfNocXOkK48P3VfalrUxsSJ74K2KfofDZNb3RQ= X-Received: by 2002:a05:6830:4982:b0:71d:5f1b:28c2 with SMTP id 46e09a7af769-71dcf50e480mr735766a34.9.1733453058218; Thu, 05 Dec 2024 18:44:18 -0800 (PST) MIME-Version: 1.0 References: <6a6439f1-8039-44e2-8fb9-59028f7f2014@mailbox.org> <9c5ba566-27b8-4e8c-bf7d-2dc561509991@mailbox.org> <41791b6d-aaf5-4fed-9cc3-e89bc49e8637@mailbox.org> <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> In-Reply-To: From: Ron Johnson Date: Thu, 5 Dec 2024 21:44:07 -0500 Message-ID: Subject: Re: Errors when restoring backup created by pg_dumpall To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000c5208c062890fd6c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c5208c062890fd6c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Dec 5, 2024 at 6:24=E2=80=AFPM David G. Johnston wrote: > On Thu, Dec 5, 2024 at 4:04=E2=80=AFPM Ron Johnson > wrote: > >> Another alternative is to open the .sql file in Notepad++, then add >> "public." before all the unqualified "earth" and "ll_to_earth" reference= s. >> > > 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 fi= le. > Then why would changing search_path work? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000c5208c062890fd6c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, Dec 5, 2024 at 6:24=E2=80=AFPM Da= vid G. Johnston <david.g.j= ohnston@gmail.com> wrote:
<= div style=3D"font-family:arial,helvetica,sans-serif">On Thu, Dec 5, 2024 at 4:04=E2=80=AFPM Ron= Johnson <r= onljohnsonjr@gmail.com> wrote:
=
Another alternative is to open the .sql fil= e in Notepad++, then add "public." before all the unqualified &qu= ot;earth" and "ll_to_earth" references.

And as discussed there are none in that file because those references a= re within an extension's objects and only create extension appears in t= he file.

Then why would c= hanging search_path work?=C2=A0

--
Death to <Redacted>, and butter sauce.
Don&#= 39;t boil me, I'm still alive.
<Redacted> lobster!
--000000000000c5208c062890fd6c--