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

PostGIS trac at osgeo.org
Mon Jun 27 10:42:38 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):

 Fair enough. I had my reservations as well especially since we don't have
 an ST_Information_Schema either.

 One thing that does have to be decided though,  is it going to be POINT (4
 dimensions in the table), or PointZ, PointZM or Point Z, Point ZM, PointM
 vs. POINTM (just a casing issue).  I think we have to decide on which way
 we go and stick with that for both typmod constrained as well as
 constraint based constrained geometry.  I don't want to have to explain
 why one shows PointZ and one shows POINT.  I'm fairly indifferent since
 most people don't use ZM that much in older versions and aside from casing
 the others are essentially the same name. I would like to keep the
 uppercase though just for backward compatibility.

 Also is my general approach fine with everyone.  If it is, was planning to
 move to change the functions -- which means making populate_geometry not
 add or delete any records from geometry_columns(just add constraints to
 tables or convert column to typmod), AddGeometryColumn same deal - will
 just add a new column.  Each I would replace with a new function that
 takes an optional argument use_typmod which we can default to true.

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