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

Sandro Santilli strk at kbt.io
Fri Feb 11 08:46:13 PST 2022

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

  - 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

  - 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.


More information about the postgis-users mailing list