[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 mcayland):

 On my Debian amd64 box I get the following with SVN trunk (r6549):

 ./shp2pgsql -s 3003 -d -g geom -D -i -I -W "UTF-8" world_borders.shp
 public.foo | less


 SET CLIENT_ENCODING TO UTF8;
 SET STANDARD_CONFORMING_STRINGS TO ON;
 SELECT DropGeometryColumn('public','foo','geom');
 DROP TABLE "public"."foo";
 BEGIN;
 CREATE TABLE "public"."foo" (gid serial PRIMARY KEY,
 "cat" float8,
 "fips_cntry" varchar(80),
 "cntry_name" varchar(80),
 "area" float8,
 "pop_cntry" float8);
 SELECT AddGeometryColumn('public','foo','geom','3003','MULTIPOLYGON',2);
 COPY "public"."foo"
 ("cat","fips_cntry","cntry_name","area","pop_cntry",geom) FROM stdin;
 1       AA      Aruba   193.00  71218.00
 0106000020BB0B00000100000001030000000100000013000000ED9C6681767851C0FC1D8A027DD22840168733BF9A7C51C0DF8C9AAF92DF284083A5BA80978351C0FA264D83A211294002F4FBFECD8351C008E6E8F17B132940EF5701BEDB8351C0F71F990E9D162940ED6305BF0D8451C0FD1186014B3E29406C21C841098451C0CCCF0D4DD941294018B14F00C58351C02B6C06B820432940ED9925016A8351C0763579CA6A4229402C11A8FE418251C0AF5A99F04B3D2940C05E61C1FD8151C004FEF0F3DF3B2940D9092FC1A97B51C083FA96395D0E2940C53A55BE677951C0D6AC33BE2FF628409A232BBF0C7951C005F86EF3C6F128406CEBA7FFAC7851C0D4B837BF61EA284045BC75FEED7751C0A27C410B09D82840C158DFC0E47751C0F4311F10E8D4284056647440127851C0D0D03FC1C5D22840ED9C6681767851C0FC1D8A027DD22840


 So it looks okay to me here? The world_borders shapefile I used for
 testing was obtained from http://mappinghacks.com/data/.

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