[postgis-devel] spatial_ref_sys

[Sandro Santilli]

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;