Re: Extension relocation vs. schema qualification

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Verona, Luiz" <luverona(at)amazon(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Extension relocation vs. schema qualification
Date: 2021-10-05 12:26:28
Message-ID: 4055680.1633436788@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

"Verona, Luiz" <luverona(at)amazon(dot)com> writes:
> I am writing to resurrect this 3-year-old thread. Attached is a patch to address earthdistance related failures during pg_restore.
> The proposed patch will:
> - Create a new version of earthdistance (1.2) and make this new version default
> - Change earthdistance relocatable from true to false

That part seems like kind of a nonstarter. People may already rely on it
being relocatable. Also, if cube is still relocatable, it could still
get broken post-installation.

I spent some time awhile ago on fixing this via new-style SQL functions
[1]. That didn't get finished for reasons explained in the thread,
but I think that's probably a more productive direction to go in.

regards, tom lane

[1] https://www.postgresql.org/message-id/flat/3395418.1618352794%40sss.pgh.pa.us

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2021-10-05 16:41:27 Re: BUG #17212: pg_amcheck fails on checking temporary relations
Previous Message Verona, Luiz 2021-10-05 09:57:36 RE: Extension relocation vs. schema qualification

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2021-10-05 12:27:59 Re: Fix pg_log_backend_memory_contexts() 's delay
Previous Message Tom Lane 2021-10-05 12:10:38 Re: plperl: update ppport.h and fix configure version check