pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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
Date: Tue, 05 Oct 2021 08:26:28 -0400
Message-ID: <4055680.1633436788@sss.pgh.pa.us> (raw)
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>

"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.pgh.pa.us





view thread (4+ messages)  latest in thread

Message-ID: <4055680.1633436788@sss.pgh.pa.us>
Permalink:  ../4055680.1633436788@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/4055680.1633436788@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, luverona@amazon.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: Extension relocation vs. schema qualification
  In-Reply-To: <4055680.1633436788@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox