Re: Errors when restoring backup created by pg_dumpall
| От | David G. Johnston |
|---|---|
| Тема | Re: Errors when restoring backup created by pg_dumpall |
| Дата | |
| Msg-id | CAKFQuwaB5GuUNuyiUbS0ah-LYXepHLPnOHrP7g8RMz8ywOm3zQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Errors when restoring backup created by pg_dumpall (PopeRigby <poperigby@mailbox.org>) |
| Ответы |
Re: Errors when restoring backup created by pg_dumpall
|
| Список | 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)))::ea rth
QUERY: SELECT cube(cube(cube(earth()*cos(radians($1))*cos(radians($2))), earth()*cos(radians($1))*sin(r adians($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.
В списке pgsql-general по дате отправления: