Content-Type: multipart/alternative;
 boundary="------------fZXL2wQDU97DauH7oHwDkMrj"
Message-ID: <41791b6d-aaf5-4fed-9cc3-e89bc49e8637@mailbox.org>
Date: Sat, 30 Nov 2024 19:36:46 -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>
 <ff94f628-27af-4c3a-9590-cba38bb5d2d1@mailbox.org>
 <CAKFQuwYQUequkYVS8SLgC1L0TOdWNK=xVyxnPD9RPPwfvYRFSQ@mail.gmail.com>
Content-Language: en-US
From: PopeRigby <poperigby@mailbox.org>
In-Reply-To: <CAKFQuwYQUequkYVS8SLgC1L0TOdWNK=xVyxnPD9RPPwfvYRFSQ@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/41791b6d-aaf5-4fed-9cc3-e89bc49e8637%40mailbox.org>
Precedence: bulk

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

On 11/30/24 18:41, David G. Johnston wrote:
> On Saturday, November 30, 2024, PopeRigby <poperigby@mailbox.org> wrote:
>
>     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?
>
> Since you are past the point of fixing the source to produce valid 
> dumps…that leaves finding the places in the text the lack the schema 
> qualification and manually adding them in.
>
> David J.
>
Oh also, it's the schema is specified as public on this line: 
https://gist.github.com/poperigby/fcb59eb6c22c6051800e06a0ec482b49#file-redacted_all-sql-L4111

Why is it not finding it? I queried public and earth was in there.

--------------fZXL2wQDU97DauH7oHwDkMrj
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 18:41, David G. Johnston
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAKFQuwYQUequkYVS8SLgC1L0TOdWNK=xVyxnPD9RPPwfvYRFSQ@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">
        <div>
          <div>On 11/30/24 17:27, David G. Johnston wrote:<br>
          </div>
          <blockquote type="cite"> On Saturday, November 30, 2024,
            PopeRigby &lt;<a href="mailto:poperigby@mailbox.org"
              target="_blank" 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))),ea<wbr>rth()*cos(radians($1))*sin(rad<wbr>ians($2))),earth()*sin(radians<wbr>($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>
        </div>
      </blockquote>
      <div>Since you are past the point of fixing the source to produce
        valid dumps…that leaves finding the places in the text the lack
        the schema qualification and manually adding them in.</div>
      <div><br>
      </div>
      <div>David J.</div>
      <div><br>
      </div>
    </blockquote>
    <p>Oh also, it's the schema is specified as public on this line:
<a class="moz-txt-link-freetext" href="https://gist.github.com/poperigby/fcb59eb6c22c6051800e06a0ec482b49#file-redacted_all-sql-L4111">https://gist.github.com/poperigby/fcb59eb6c22c6051800e06a0ec482b49#file-redacted_all-sql-L4111</a><br>
      <br>
      Why is it not finding it? I queried public and earth was in there.<br>
    </p>
  </body>
</html>

--------------fZXL2wQDU97DauH7oHwDkMrj--