[postgis-tickets] [PostGIS] #4403: Make shp2pgsql -s : work with -D

[PostGIS]

#4403: Make shp2pgsql -s : work with -D
---------------------------+---------------------------
 Reporter:  robe           |      Owner:  robe
     Type:  enhancement    |     Status:  assigned
 Priority:  medium         |  Milestone:  PostGIS 3.0.0
Component:  loader/dumper  |    Version:  trunk
 Keywords:                 |
---------------------------+---------------------------
 Right now the -s <some srid>:<to other srid>  doesn't work with -D option.

 This is because it uses INSERT commands with a ST_Transform.

 So I usually end up not using it because it's slower than using -D + ALTER
 ... table change the projection.

 What I was thinking is why don't we just have the shp2pgsql command do
 that -- do the ALTER right after if the user chooses to use -D.

 The other alternative is to build real proj support into shp2pgsql, but
 I'd much rather not do that because then we might run into issues with the
 client computer using shp2pgsql having different install from the server
 and also wouldn't take care of cases where user manually installs their
 own entries in the server.

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