[postgis-devel] spatial_ref_sys

[Regina Obe]

I'm okay with not backporting as long as we make clear we don't update
spatial_ref_sys.

I think all users assumed an upgrade would provide new spatial_ref_sys
entries as well.

So some documentation needs to be in place to note that and what to do about
it if we don't include in upgrade scripts.

> -----Original Message-----
> From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On
> Behalf Of Sandro Santilli
> Sent: Wednesday, February 16, 2022 11:59 AM
> To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
> Subject: Re: [postgis-devel] spatial_ref_sys
> 
> On Wed, Feb 16, 2022 at 08:28:44AM -0800, Paul Ramsey wrote:
> > So, still...
> > I merged in this pull request to master
> >
> > https://github.com/postgis/postgis/pull/665
> >
> > Which isn't much, just a one-insert spatial_ref_sys table with a no-op
on
> conflict, and adding that to the upgrade scripts.
> >
> > Sandro in the PR discussion mentioned not wanting to back port.
> > Regina had an opinion on that, but I don't know if it's strongly held.
> > I'm backing away quietly, as I think spatial reference systems are not a
core
> piece of concern.
> > Discuss!
> 
> My rationale for not backporting it is:
> 
>   - It's not a clear *BUG* that spatial_ref_sys table is not updated
>     on postgis EXTENSION upgrade. Rather, it is a long-standing fact
>     (it's been like this since the start of EXTENSION postgis).
> 
>   - Only adding records for not-already-taken SRIDs while leaving
>     records with conflicting SRIDs untouched is not giving the
>     *same* records for NEWLY CREATED and UPGRADED databases with
>     PostGIS extension, which I think is still confusing (no WARNING
>     is being printed on DO NOTHING, not sure if NOTICEs are).
> 
>   - I think a clear overall plan needs to be agreed upon for
>     spatial_ref_sys behavioural changes.
> 
> 
> --strk;
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel