[postgis-devel] spatial_ref_sys view

[Sandro Santilli]

On Fri, Feb 04, 2022 at 01:27:40PM -0500, Regina Obe wrote:

> but the fact that many do
> 
> INSERT INTO spatial_ref_sys VALUES (a....)

Not only "many do", but OGC standard dictates exact
structure of that view/table:
file:///tmp/mozilla_strk0/06-104r3_Candidate_Implementation_Specification_for_Geographic_Information_-_Simple_feature_access_-_Part_2_SQL_option_v1.2.0.pdf

Excerpt:

  7.1.2.2 Table constructs

  The following CREATE TABLE statement creates an appropriately structured SPATIAL_REF_SYS table.
  This table may be an updatable view of an implementation-specific table.
  Implementations shall either use this table format or provide stored procedures to create, to populate and to maintain this table

  CREATE TABLE SPATIAL_REF_SYS
  (
    SRID INTEGER NOT NULL PRIMARY KEY,
    AUTH_NAME CHARACTER VARYING,
    AUTH_SRID INTEGER,
    SRTEXT CHARACTER VARYING(2048)
  )

My proposal is the "updatable view".
 
--strk;

  Libre GIS consultant/developer
  https://strk.kbt.io/services.html