[postgis-devel] [PostGIS] #1759: shp2pgsql st_transform not unique requires casting

[PostGIS]

#1759: shp2pgsql st_transform not unique requires casting
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  blocker  |   Milestone:  PostGIS 2.0.1
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------
 shp2pgsql is emitting code like this


 {{{
 ST_Transform('0101000020E61000009A081B9E5E9557C0006F8104C51F4440', 900913)
 }}}


 If you use ST_Transform.  However if you have raster installed in your db,
 you get an ST_Transform is not unique notice, because raster also has an
 ST_Transform function.

 This needs to be changed to


 {{{
 ST_Transform('0101000020E61000009A081B9E5E9557C0006F8104C51F4440'::geometry,
 900913);
 }}}

 See user posting:
 http://postgis.refractions.net/pipermail/postgis-
 users/2012-April/033534.html

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