[postgis-users] shp2pgsql changes data values during sql dump
pramsey at refractions.net
Fri Mar 17 14:21:53 PST 2006
Open your dbf file in hexedit. I guarantee you, you will find
"Lighted" and "Not lighted" in there. shp2pgsql is not making this
stuff, unless Sandro snuck an AI routine into the code while I was
not looking :)
On Mar 17, 2006, at 1:47 AM, Christian Michels wrote:
> Dear List,
> I use postgres version 8.1.3 on Windows 2003 Server and PostGis
> Version "POSTGIS="1.0.4" GEOS="2.1.4" PROJ="Rel. 4.4.9, 29 Oct
> 2004" USE_STATS DBPROC="0.3.0" RELPROC="0.3.0".
> I face some really strange problems during a shp2pgsql dump of a
> shapefile into a sql file.
> I execute the following ...
> shp2pgsql -s 4326 -D SHPFILE SHPFILETABLE learning > "D:
> The dump runs without any error message. But when I look at the
> resulting sql file I recognized some strange values which are not
> in the shapefile. There is one field defined as - "light" int8 -
> this is correct and the same definition like in the SHP file. The
> field values in the shapfile are 0 and I would expect a 0 in the
> sql dump file BUT I get the values "Not lighted" or "Lighted". I
> have no idea where these strings come from. Trying to load the sql
> file to postgres results in the error that a string cannot be
> written into a int8 field which is clear so far ! But why does
> change the value from 0 to a string during the dump process ??
> Any help is very much apprechiated !
> Thanx - Chris
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users