MIME-Version: 1.0
In-Reply-To: <9c5ba566-27b8-4e8c-bf7d-2dc561509991@mailbox.org>
References: <6a6439f1-8039-44e2-8fb9-59028f7f2014@mailbox.org>
 <cba48d2c-0987-4233-a86f-2e693677efd3@aklaver.com> <9c5ba566-27b8-4e8c-bf7d-2dc561509991@mailbox.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 30 Nov 2024 18:27:26 -0700
Message-ID: <CAKFQuwaB5GuUNuyiUbS0ah-LYXepHLPnOHrP7g8RMz8ywOm3zQ@mail.gmail.com>
Subject: Re: Errors when restoring backup created by pg_dumpall
To: PopeRigby <poperigby@mailbox.org>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000bcb71106282b5527"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwaB5GuUNuyiUbS0ah-LYXepHLPnOHrP7g8RMz8ywOm3zQ%40mail.gmail.com>
Precedence: bulk

--000000000000bcb71106282b5527
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Saturday, November 30, 2024, PopeRigby <poperigby@mailbox.org> wrote:

> On 11/29/24 17:47, Adrian Klaver wrote:
>
>> On 11/29/24 17:34, PopeRigby wrote:
>>
>> psql:all.sql:4104: ERROR:  type "earth" does not exist
>> LINE 1: ...ians($1))*sin(radians($2))),earth()*sin(radians($1)))::earth
>>
>> QUERY:  SELECT cube(cube(cube(earth()*cos(radians($1))*cos(radians($2)))=
,
>> earth()*cos(radians($1))*sin(radians($2))),earth()*sin(radia
>> ns($1)))::earth
>> CONTEXT:  SQL function "ll_to_earth" during inlining
>>  The earthdistance module is even getting added between the table with
>> the earth type is added, so shouldn't there be no problem?
>>
>
The fact that =E2=80=9Cearth=E2=80=9D is not schema qualified leads me to s=
uspect you are
getting bit by safe search_path environment rules.

David J.

--000000000000bcb71106282b5527
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Saturday, November 30, 2024, PopeRigby &lt;<a href=3D"mailto:poperigby@m=
ailbox.org">poperigby@mailbox.org</a>&gt; wrote:<br><blockquote class=3D"gm=
ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le=
ft:1ex">On 11/29/24 17:47, Adrian Klaver wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
On 11/29/24 17:34, PopeRigby wrote:<br>
<br>
psql:all.sql:4104: ERROR:=C2=A0 type &quot;earth&quot; does not exist<br>
LINE 1: ...ians($1))*sin(radians($2)))<wbr>,earth()*sin(radians($1)))::ea<w=
br>rth<br>
<br>
QUERY:=C2=A0 SELECT cube(cube(cube(earth()*cos(rad<wbr>ians($1))*cos(radian=
s($2))),<wbr>earth()*cos(radians($1))*sin(r<wbr>adians($2))),earth()*sin(ra=
dia<wbr>ns($1)))::earth<br>
CONTEXT:=C2=A0 SQL function &quot;ll_to_earth&quot; during inlining<br>=C2=
=A0The earthdistance module is even getting added between the table with th=
e earth type is added, so shouldn&#39;t there be no problem?<br></blockquot=
e></blockquote><div><br></div><div>The fact that =E2=80=9Cearth=E2=80=9D is=
 not schema qualified leads me to suspect you are getting bit by safe searc=
h_path environment rules.</div><div><br></div><div>David J.=C2=A0</div>

--000000000000bcb71106282b5527--