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

PostGIS trac at osgeo.org
Fri May 13 01:29:29 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):


 I think you missed my two main points
 1) If we expect people tomove to PostGIS 2.0, there current tables built
 with AddGeometryColumn should work as they did before.  It would be
 painful to have them alter their geometry columns to typmod.  With that
 said -- the postgresql catalog will be wrong for these geometries.

 2) For inheritance tables -- it is not unusual and I don't think bad
 practice to have each child have a separate geometry type (though it
 should have the same srid and dimension).  typmod simply doesn't work for
 this model.

 3) There are varying degrees -- e.g. I think for example Oracle doesn't
 mind POLYGON/MULTIPOLYGON coexisting.  Neither do ESRI Shapefiles.  When
 you have a polygon in must cases it is more efficient to keep it that way
 than wrapping it in a multi wrapper. typmod doesn't work for this either.

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