PopeRigby <poperi...@mailbox.org> writes:
> I've applied the following patch to postgres:
> https://www.postgresql.org/message-id/attachment/122092/0002-earthdistance-sql-functions.patch
Cool. You did actually install the new scripts into your target
installation, right?
> I'm still getting this error:
> psql:all.sql:4102: ERROR: type "earth" does not exist
> LINE 1: ...ians($1))*sin(radians($2))),earth()*sin(radians($1)))::earth
Hmmm ... a pg_dumpall output script shouldn't really contain that
function body directly; it should just say "CREATE EXTENSION
earthdistance". Is it possible that this database is so old that
it contains a pre-extension (pre-9.1) version of earthdistance?
regards, tom lane
