On 12/10/24 19:05, PopeRigby wrote:
On 12/9/24 16:31, Adrian Klaver wrote:
On 12/9/24 15:30, PopeRigby wrote:
On 12/9/24 15:23, Tom Lane wrote:
Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes:
You could file an issue here:
https://www.postgresql.org/account/login/?next=/account/submitbug/
Ask if the developers could use the mechanisms available here:
https://www.postgresql.org/docs/current/extend-extensions.html#EXTEND-EXTENSIONS-RELOCATION
This wouldn't really move the needle, since (a) there is not some
magic group of people that will become involved who aren't already
and (b) the requested fix seems exactly the same as the work
already in progress at [1].
What would help is to figure out why the proposed patch didn't
seem to work for you. I continue to suspect that you didn't
really install the updated extension, but it's unclear.
regards, tom lane
[1]
https://www.postgresql.org/message-id/flat/3395418.1618352794@xxxxxxxxxxxxx
I compiled and installed PostgreSQL with the patch, and restarted it,
so unless there are other steps I'm not sure what I could have done
wrong.
What was the source of the patch?
This:
https://www.postgresql.org/message-id/attachment/122092/0002-earthdistance-sql-functions.patch
If I am following correctly I believe you need this one:
https://www.postgresql.org/message-id/attachment/166859/v2-0002-Use-new-style-SQL-function-in-earthdistance-exten.patch
It has the changes that include the schema qualifications. The one you
used does not have those modifications.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
