| From: | PopeRigby <poperigby(at)mailbox(dot)org> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| 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 02:11:18 |
| Message-ID: | ff94f628-27af-4c3a-9590-cba38bb5d2d1@mailbox.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/30/24 17:27, David G. Johnston wrote:
> 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(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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2024-12-01 02:41:27 | Re: Errors when restoring backup created by pg_dumpall |
| Previous Message | David G. Johnston | 2024-12-01 01:27:26 | Re: Errors when restoring backup created by pg_dumpall |