[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