Content-Type: multipart/alternative;
 boundary="------------quYyZokvUojvZRzb6NV4Mypb"
Message-ID: <ff94f628-27af-4c3a-9590-cba38bb5d2d1@mailbox.org>
Date: Sat, 30 Nov 2024 18:11:18 -0800
MIME-Version: 1.0
Subject: Re: Errors when restoring backup created by pg_dumpall
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>,
 "pgsql-general@postgresql.org" <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>
Content-Language: en-US
From: PopeRigby <poperigby@mailbox.org>
In-Reply-To: <CAKFQuwaB5GuUNuyiUbS0ah-LYXepHLPnOHrP7g8RMz8ywOm3zQ@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/ff94f628-27af-4c3a-9590-cba38bb5d2d1%40mailbox.org>
Precedence: bulk

This is a multi-part message in MIME format.
--------------quYyZokvUojvZRzb6NV4Mypb
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

On 11/30/24 17:27, David G. Johnston wrote:
> 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(radians($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 “earth” is not schema qualified leads me to suspect you 
> are getting bit by safe search_path environment rules.
>
> David J.

Ah. How can I fix that?

--------------quYyZokvUojvZRzb6NV4Mypb
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 11/30/24 17:27, David G. Johnston
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAKFQuwaB5GuUNuyiUbS0ah-LYXepHLPnOHrP7g8RMz8ywOm3zQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      On Saturday, November 30, 2024, PopeRigby &lt;<a
        href="mailto:poperigby@mailbox.org" moz-do-not-send="true"
        class="moz-txt-link-freetext">poperigby@mailbox.org</a>&gt;
      wrote:<br>
      <blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On
        11/29/24 17:47, Adrian Klaver wrote:<br>
        <blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
          On 11/29/24 17:34, PopeRigby wrote:<br>
          <br>
          psql:all.sql:4104: ERROR:  type "earth" does not exist<br>
          LINE 1: ...ians($1))*sin(radians($2)))<wbr>,earth()*sin(radians($1)))::ea<wbr>rth<br>
          <br>
          QUERY:  SELECT cube(cube(cube(earth()*cos(rad<wbr>ians($1))*cos(radians($2))),<wbr>earth()*cos(radians($1))*sin(r<wbr>adians($2))),earth()*sin(radia<wbr>ns($1)))::earth<br>
          CONTEXT:  SQL function "ll_to_earth" during inlining<br>
           The earthdistance module is even getting added between the
          table with the earth type is added, so shouldn't there be no
          problem?<br>
        </blockquote>
      </blockquote>
      <div><br>
      </div>
      <div>The fact that “earth” is not schema qualified leads me to
        suspect you are getting bit by safe search_path environment
        rules.</div>
      <div><br>
      </div>
      <div>David J. </div>
    </blockquote>
    <p>Ah. How can I fix that?<br>
    </p>
  </body>
</html>

--------------quYyZokvUojvZRzb6NV4Mypb--