[postgis-devel] [PostGIS] #748: shp2pgsql use wrong schema name

[PostGIS]

#748: shp2pgsql use wrong schema name
-----------------------+----------------------------------------------------
 Reporter:  aperi2007  |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.0.0
Component:  postgis    |     Version:  trunk        
 Keywords:             |  
-----------------------+----------------------------------------------------

Comment(by robe):

 Mark,

  I tried with a table using my December 30th build I had posted which is
 the one Andrea is using, and I get the same problem with any table.
 It stuffs in an extra ..

 when I run this:

 shp2pgsql -s 4269 -d -g geom -D -i -I -W "UTF-8" place public.place >
 places.sql

 The output of my file looks like:


 {{{
 SELECT DropGeometryColumn('public.','place','geom');
 DROP TABLE "public."."place";
 }}}

 I tried with different schemas and quoting the schema and it does the same
 thing - its not parsing the schema name out right.

 Mark -- I presume its more than just a MingW problem since Andrea says it
 happens on his Debian install as well. I don't think its getopt either.

  I think maybe the period check or something is wrong in shp2pgsql-cli.c
 (somewhere around line 185-190) and maybe its specific to 32/64 bit maybe?

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/748#comment:6>
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.