[postgis-devel] [PostGIS] #1152: SRID_MAXIMUM should be raised, gserialized_get/set_srid () should be patched and typemod int too

PostGIS trac at osgeo.org
Sun Aug 7 07:27:52 PDT 2011


#1152: SRID_MAXIMUM should be raised, gserialized_get/set_srid () should be
patched and typemod int too
----------------------+-----------------------------------------------------
  Reporter:  vince    |       Owner:  pramsey       
      Type:  defect   |      Status:  closed        
  Priority:  medium   |   Milestone:  PostGIS 2.0.0 
 Component:  postgis  |     Version:  trunk         
Resolution:  invalid  |    Keywords:  srid liblwgeom
----------------------+-----------------------------------------------------

Comment(by robe):

 It's stored as a number in the pg_attribute.atttypmod column for each
 table column.

 so if a geometry column was created with the form ADD COLUMN
 geometry(POINT,4326)
 you'll see a number in that column corresponding to that.  If it was
 created without typmod, that record would have -1 in the column.

 The new geometry_columns view checks both typmod and constraints
 and uses the helper functions postgis_typmod_* and postgis_constraint_* to
 parse out the relevant srid, dim and type information from the typmod
 number or table constraints.

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