[postgis-tickets] [PostGIS] #4569: Allow SRID coercion when inserting unknown SRID geometry into known SRID column

[PostGIS]

#4569: Allow SRID coercion when inserting unknown SRID geometry into known SRID
column
-------------------------+---------------------------
 Reporter:  pramsey      |      Owner:  pramsey
     Type:  enhancement  |     Status:  new
 Priority:  medium       |  Milestone:  PostGIS 3.1.0
Component:  postgis      |    Version:  trunk
 Keywords:               |
-------------------------+---------------------------
 Currently, inserting a SRID=0 geometry into a column with SRID typmod
 results in an error, so:
 {{{
 CREATE TABLE foo (g geometry(point, 4326));
 INSERT INTO foo ( 'POINT(1 1)' );
 }}}
 does not work. This results in a lot of extra hand waving just to get data
 into place, and in teaching environments is annoying. The intent of
 putting unknown things into known places is fairly clear: we mean for them
 to be in the same reference system.

 This change will allow the above, but all other cases will remain the
 same: mis-matched known SRID will still generate errors.

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