[postgis-devel] [PostGIS] #944: typmod support for PostGIS geometry

PostGIS trac at osgeo.org
Mon May 9 22:32:16 PDT 2011

#944: typmod support for PostGIS geometry
 Reporter:  robe         |       Owner:  pramsey      
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.0.0
Component:  postgis      |     Version:  trunk        
 Keywords:               |  

Comment(by robe):

 My gut feeling says we should keep AddGeometryColumn, populate etc. more
 or less as is so they still do the add constraint thing and register into
 geometry_columns or a new table called


 So here is my thought for merging the old with the new world.

 st_geometry_columns -- a view parallel in concept to geography_columns
 that just inspects the catalogs -- perhaps just leaves out geometry
 columns with no typmod info (or includes them I guess marking them as just
 geometry). this is a true SQL/MM implementation.

 geometry_columns -- a view that unions st_geometry_columns (except for
 those just marked as geometry) with geometry_columns_legacy. So old
 applications can continue to work as they did before.

 The populate, addgeometrycolumns etc. will just populate
 geometry_columns_legacy.  We will expect all people expecting the new
 behavior to use the typmod behavior for creating geometries.  It would
 also only add constraints to columns that don't use typmod construction.

 Any thoughts / issues people see?

Ticket URL: <http://trac.osgeo.org/postgis/ticket/944#comment:1>
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-devel mailing list