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

PostGIS trac at osgeo.org
Mon May 16 05:48:11 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 mcayland):

 I think that if we went as far as having a hybrid solution, it would just
 cause even more chaos in the long run. As Paul mentions up-thread, do we
 want to be stuck with an ugly hack forever?

 For point 1, converting a varchar(50) to a varchar(1000) can be done
 easily with a single catalog query because the internal representation
 doesn't change. In the same way that setting a typmod for a mixed column
 can be done in the same way because by changing from a sub-class to a
 super-class, we can guarantee that all of the criteria can be met and so
 we don't need to check every single row. We would have to visit every row
 if going the other way, but I don't think that's the common use case.

 For point 3, I think we would need to see which tools have these issues in
 order to get a feel for whether or not this would be a real problem.

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