On Saturday, November 30, 2024, PopeRigby <poperi...@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.
