Re: Errors when restoring backup created by pg_dumpall - Mailing list pgsql-general

From PopeRigby
Subject Re: Errors when restoring backup created by pg_dumpall
Date
Msg-id ff94f628-27af-4c3a-9590-cba38bb5d2d1@mailbox.org
Whole thread Raw
In response to Re: Errors when restoring backup created by pg_dumpall  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Errors when restoring backup created by pg_dumpall
List pgsql-general
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?

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Errors when restoring backup created by pg_dumpall
Next
From: "David G. Johnston"
Date:
Subject: Re: Errors when restoring backup created by pg_dumpall