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

PostGIS trac at osgeo.org
Tue May 10 19:21:35 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):

 Normally I'd be the first to say down with the past except in this case
 I'm not convinced the new way is always superior to the past. Then again I
 think about my frustrating arguments with Josh Berkus how he thinks people
 should just use text and put size checks on their fields. Feels funny
 being on the other side of the argument.

 If we are going to make the old functions wrappers around ALTER TABLE,
 what am I going to do about my case when I want POLYGONS/MULTIPOLYGONS in
 the same table because in many cases, there isn't any reason to treat them
 separately.  Also the case of inheritance.  Now my work flow is so much
 more complicated.  Before I would just add it as a MULTIPOLYGON and
 manually relax the type constraint to allow POLYGONS. Also the case with
 the inheritance thing I talked about.

 I know Paul is thinking "Why is it always about you, Regina?".  Cause I'm
 the first use case I can think of :).

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