On 11/30/24 19:45, David G. Johnston wrote:
On Saturday, November 30, 2024, PopeRigby <poperi...@mailbox.org> wrote:
On 11/30/24 18:41, David G. Johnston wrote:
On Saturday, November 30, 2024, PopeRigby <poperi...@mailbox.org>
wrote:
On 11/30/24 17:27, David G. Johnston wrote:
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(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?
Since you are past the point of fixing the source to produce
valid dumps…that leaves finding the places in the text the lack
the schema qualification and manually adding them in.
David J.
Oh also, it's the schema is specified as public on this line:
https://gist.github.com/poperigby/fcb59eb6c22c6051800e06a0ec482b49#file-redacted_all-sql-L4111
<https://gist.github.com/poperigby/fcb59eb6c22c6051800e06a0ec482b49#file-redacted_all-sql-L4111>
Why is it not finding it? I queried public and earth was in there.
Ok, so the error is not emanating from your code but rather the body
of the ll_to_earth function defined in the earthdistance extension.
David J.
By code do you mean my sql file created by pg_dumpall? Sorry, I'm just a
self-hoster so I'm not very well versed in Postgres. I'm just trying to
get my server back online.
