From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | PopeRigby <poperigby(at)mailbox(dot)org> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Errors when restoring backup created by pg_dumpall |
Date: | 2024-12-01 01:27:26 |
Message-ID: | CAKFQuwaB5GuUNuyiUbS0ah-LYXepHLPnOHrP7g8RMz8ywOm3zQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Saturday, November 30, 2024, PopeRigby <poperigby(at)mailbox(dot)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 “earth” is not schema qualified leads me to suspect you are
getting bit by safe search_path environment rules.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | PopeRigby | 2024-12-01 02:11:18 | Re: Errors when restoring backup created by pg_dumpall |
Previous Message | PopeRigby | 2024-12-01 01:17:31 | Re: Errors when restoring backup created by pg_dumpall |