From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Verona, Luiz" <luverona@amazon.com>
cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Extension relocation vs. schema qualification
In-reply-to: <3a89b08b90ac4aef99bce42ba7a23c67@EX13D20EUC002.ant.amazon.com>
References: <152106914669.1223.5104148605998271987@wrigleys.postgresql.org>
 <20180330205229.GS8476@momjian.us> <20180402202402.GA24073@momjian.us>
 <20180405065957.GA2276534@rfd.leadboat.com>
 <20180710014308.GA805781@rfd.leadboat.com>
 <3a89b08b90ac4aef99bce42ba7a23c67@EX13D20EUC002.ant.amazon.com>
Comments: In-reply-to "Verona, Luiz" <luverona@amazon.com>
	message dated "Tue, 05 Oct 2021 09:57:36 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <4055679.1633436788.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 05 Oct 2021 08:26:28 -0400
Message-ID: <4055680.1633436788@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/4055680.1633436788%40sss.pgh.pa.us>
Precedence: bulk

"Verona, Luiz" <luverona@amazon.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.pg=
h.pa.us