[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