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

PostGIS trac at osgeo.org
Wed May 11 18:04:28 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):

 SELECT all geometry columns with a geometry type (not like geometry)
 UNION ALL
 geometry_columns_old

 How about this Paul, you go do your typmod thing since that's a known we
 want and we have no differences in opinion how that should be done.

 I'll do the view, the revision of all the management functions.  I'll even
 write the pre install script that renames peoples existing
 geometry_columns should they have one and I'll submit this as a patch for
 you to tear apart and do what you will with. Deal?

 BTW: we also need to change the loader.  I think as a clean beginning it
 should check versions of PostGIS and for version of PostGIS 2.0+ it should
 use the standard CREATE TABLE ...geometry(..) instead of the management
 functions.  Would be nice if we had a switch option to allow people to
 choose the old addgeometrycolumns or new typmod behavior and default to
 new behavior, but that should go in as a separate ticket I think.

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