[postgis-devel] [PostGIS] #286: Change "no SRID" SRID to 0

[PostGIS]

#286: Change "no SRID" SRID to 0
---------------------+------------------------------------------------------
 Reporter:  pramsey  |       Owner:  pramsey      
     Type:  task     |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 strk -- geometry_columns just puts in 0 for SRID if the SRID has a
 constraint of unknown or its unspecified.  The main reason I don't want us
 to bother putting in a constraint is our system can't distinguish between
 unknown and a mixed bag of geometries.  So why bother making the
 distinction in constraint and god forbid we need to change unknown later
 -- enforching unknown will just bite us.  I think its more important to
 just stare people from using unknown unless they absolutely need to.
 Putting so much significance on it is not going to help that cause.  It's
 all academic.

 Getting back to distinction if you have a geometry defined like
 geometry(POLYGON)

 Typmod doesn't care what you put in for srid as long as all items are
 polygons so why should constraint care?  Its like varchar  with no length
 qualifier -- it can be as long as you want (or what can be held)

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/286#comment:15>
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.