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

PostGIS trac at osgeo.org
Wed Feb 3 14:09:32 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):

 Those both seem to output valid runs:
 {{{
 paul-ramseys-macbook-2:~ pramsey$  ~/Code/postgis-svn/loader/shp2pgsql -a
 -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;
 INSERT INTO "dbftest" ("id","name") VALUES ('1','Paul');
 COMMIT;
 paul-ramseys-macbook-2:~ pramsey$  ~/Code/postgis-svn/loader/shp2pgsql -n
 -a -W "latin1" dbftest.dbf
 SET CLIENT_ENCODING TO UTF8;
 SET STANDARD_CONFORMING_STRINGS TO ON;
 BEGIN;
 INSERT INTO "dbftest" ("id","name") VALUES ('1','Paul');
 COMMIT;
 }}}

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


More information about the postgis-devel mailing list