[postgis-devel] [PostGIS] #1596: UpdateGeometryColumn allows invalid SRIDs

PostGIS trac at osgeo.org
Wed Feb 22 03:28:50 PST 2012

#1596: UpdateGeometryColumn allows invalid SRIDs
 Reporter:  mwtoews  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
 As hinted from #1594, you can !AddGeometryColumn with an unknown SRID,
 then use UpdateGeometrySRID to sneak in an invalid SRID -- one that is not
 in spatial_ref_sys:
 -- All good
 create table a (gid serial primary key);
 select AddGeometryColumn('a', 'geom', -1, 'POINT', 2);

 -- Shouldn't happen
 select UpdateGeometrySRID('a', 'geom', 123456);

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