[PostGIS] #5978: geometry_columns not showing right SRID and Type for constraint based geometry columns

[PostGIS]

#5978: geometry_columns not showing right SRID and Type for constraint based
geometry columns
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  high     |  Milestone:  PostGIS 3.5.4
Component:  postgis  |    Version:  3.5.x
 Keywords:           |
---------------------+---------------------------
 As noted in mailing list https://lists.osgeo.org/pipermail/postgis-
 users/2025-August/046843.html

 The change in #4829 apparently broke constraint support at least for srid
 and type.

 Example to replicate:


 {{{
 CREATE SCHEMA IF NOT EXISTS map;
 CREATE TABLE map.t1 (
   OBJECTID SERIAL NOT NULL,
   PKEY     INTEGER,
   PRIMARY KEY ( OBJECTID )  );

 SELECT public.AddGeometryColumn ('map', 't1', 'shape',  4326,
 upper('POINT'), 2, false);

 SELECT * FROM public.geometry_columns WHERE f_table_name = 't1';
 }}}


 outputs:


 {{{
   f_table_catalog  | f_table_schema | f_table_name | f_geometry_column |
 coord_dimension | srid |   type
 -------------------+----------------+--------------+-------------------+-----------------+------+----------
  postgis_35_sample | map            | t1           | shape             |
 2 |    0 | GEOMETRY
 }}}


 Only tested on windows, haven't confirmed it's an issue on other OS.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5978>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.