Re: [postgis-devel] About EXTENSION from UNPACKAGED on PostgreSQL 13

On 2/26/20 10:52 AM, Sandro Santilli wrote:

> This part is not clear to me. You're _assuming_ that the unpackaged--xxx
> will not make checks, so you _drop_ support for it ? Can't the normal
> extension script also be unsafe for some reason ? Or can't the
> unpackaged-xxx script be made safe by the publishers ? Or, as a last
> resort.. can't you just mark postgis as UNSAFE and still require
> superuser, which would give us the same experience as before ?

I am wondering: does anything in the PG 13 change preclude writing
a postgis_raster--unpackaged.sql script that could be applied with
CREATE EXTENSION postgis_raster VERSION unpackaged;
and would do perhaps nothing at all, or merely confirm that the
right unpackaged things are present and are the right things...

... from which an ALTER EXTENSION postgis_raster UPDATE TO 3.0;
would naturally run the existing postgis_raster--unpackaged--3.0.sql
and execute all of its existing ALTER EXTENSION ... ADD operations?

Has the disadvantage of being goofy, but possibly the advantage of
being implementable in the current state of affairs.

Regards,
-Chap