[postgis-users] Help shaping the future: how do your use of spatial_ref_sys ?

[Sandro Santilli]

On Thu, Feb 10, 2022 at 09:10:38AM -0600, Jim Klassen wrote:
> 
> How do other people handle conflicting srids?

That's a good question. For sure at the time PostGIS doesn't
give official advice about this. Current state of things is:

  - PostGIS upgrade via EXTENSION won't touch spatial_ref_sys
    table

  - PostGIS upgrade via loading spatial_ref_sys.sql will
    perform a sequence of INSERT in a few transaction,
    any transaction attempting to INSERT an already existing
    SRID will fail and result in no insert at all from that
    batch

  - PostGIS upgrades via dump/postgis_restore will DISCARD
    entries found in dump which are already provided by
    the table found in the target database.
    
This whole thread is to shape a general unified way to handle
those conflicting srids.

--strk;