Horton

Re: Errors when restoring backup created by pg_dumpall

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: PopeRigby <poperigby@mailbox.org>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2024-12-01T01:27:26Z
Lists: pgsql-general 
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(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.

Commits

  1. contrib/earthdistance: Use SQL-standard function bodies.