[postgis-devel] [PostGIS] #406: DBF only load in shp2pgsql is broken

PostGIS trac at osgeo.org
Wed Feb 3 13:51:25 PST 2010


#406: DBF only  load in shp2pgsql is broken
----------------------+-----------------------------------------------------
  Reporter:  robe     |       Owner:  pramsey      
      Type:  defect   |      Status:  closed       
  Priority:  high     |   Milestone:  PostGIS 1.5.0
 Component:  postgis  |     Version:  trunk        
Resolution:  invalid  |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by pramsey):

 I realized my test wasn't exactly like yours because my dbf file was next
 to shp and shx files, so I removed them and dropped the -n flag, but the
 import still was valid.
 {{{
 $ ~/Code/postgis-svn/loader/shp2pgsql -p -W "latin1" dbftest.dbf
 dbftest.dbf: shape (.shp) or index files (.shx) can not be opened, will
 just import attribute data.
 SET CLIENT_ENCODING TO UTF8;
 SET STANDARD_CONFORMING_STRINGS TO ON;
 BEGIN;
 CREATE TABLE "dbftest" (gid serial PRIMARY KEY,
 "id" numeric(11,0),
 "name" varchar(4));
 COMMIT;
 }}}

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


More information about the postgis-devel mailing list