Windows 17.6, 16.10, PostGIS 3.5.3 For some reason I did not see this when I started testing 3.5.3 a couple of months ago. After I removed the earlier 3.5.2 and reinstalled 3.5.3, saw the query return an unknonw SRID instead of the stated one.
DROP TABLE map.t1; CREATE TABLE map.t1 ( OBJECTID SERIAL NOT NULL, PKEY INTEGER, PRIMARY KEY ( OBJECTID ) ); SELECT public.AddGeometryColumn ('map', 't1', 'shape', 4326, upper('POINT'), 2, false); addgeometrycolumn ------------------------------------------- map.t1.shape SRID:4326 TYPE:POINT DIMS:2 SELECT f_table_schema AS schema, f_table_name AS table, f_geometry_column AS column, coord_dimension AS Dimension, srid FROM public.geometry_columns; PostGIS 3.5.2 schema | table | column | dimension | srid --------+------------------------+--------+-----------+------ map | t1 | shape | 2 | 4326 PostGIS 3.5.3 schema | table | column | dimension | srid --------+------------------------+--------+-----------+------ map | t1 | shape | 2 | 0 But describe table looks fine: \d t1 Table "map.t1" Column | Type | Collation | Nullable | Default ----------+----------+-----------+----------+-------------------------------------- objectid | integer | | not null | nextval('t1_objectid_seq'::regclass) pkey | integer | | | shape | geometry | | | Indexes: "t1_pkey" PRIMARY KEY, btree (objectid) Check constraints: "enforce_dims_shape" CHECK (st_ndims(shape) = 2) "enforce_geotype_shape" CHECK (geometrytype(shape) = 'POINT'::text OR shape IS NULL) "enforce_srid_shape" CHECK (st_srid(shape) = 4326) Thanks, Michael