[PostGIS] #1705: Get constraint-based columns in views to register correctly

PostGIS trac at osgeo.org
Sun Jun 21 13:32:50 PDT 2026


#1705: Get constraint-based columns in views to register correctly
--------------------------+-----------------------------
  Reporter:  robe         |      Owner:  robe
      Type:  enhancement  |     Status:  closed
  Priority:  medium       |  Milestone:  PostGIS Fund Me
 Component:  postgis      |    Version:  master
Resolution:  fixed        |   Keywords:
--------------------------+-----------------------------
Changes (by Darafei Praliaskouski <me@…>):

 * resolution:   => fixed
 * status:  new => closed

Comment:

 In [changeset:"4c65e7d664d7fb279c90f80674573b940a662dce/git"
 4c65e7d6/git]:
 {{{#!CommitTicketReference repository="git"
 revision="4c65e7d664d7fb279c90f80674573b940a662dce"
 Infer geometry_columns constraints for direct views

 Teach geometry_columns to inherit constraint-derived geometry metadata
 from direct view and materialized-view columns by reading top-level
 rewrite-rule origin metadata. Keep expression outputs generic unless they
 carry an explicit typmod cast.

 Parse only the top-level target list so nested subqueries cannot make an
 expression column inherit base-table constraints.

 Closes #1705

 Closes https://github.com/postgis/postgis/pull/1065
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/1705#comment:6>
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.


More information about the postgis-tickets mailing list