Thread: FW: [postgis-users] ": can't parse "ne 1, pg_atoi: error in " &empty strings in shp2pgsql output...
FW: [postgis-users] ": can't parse "ne 1, pg_atoi: error in " &empty strings in shp2pgsql output...
From
"Mike Leahy"
Date:
On Norman's recommendation, I'm forwarding this question to you... I look forward to your response. Mike -----Original Message----- From: postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of Norman Vine Sent: September 13, 2003 8:48 PM To: PostGIS Users Discussion Subject: RE: [postgis-users] ": can't parse "ne 1, pg_atoi: error in " &empty strings in shp2pgsql output... Mike Leahy writes: > > I've just installed Cygwin (on WinXP) and compiled the latest > available versions of PostgreSQL/PostGIS. > > When I run a COPY query to import data from a tab-separated DOS-text > file I get the following message: > > ": can't parse "ne 1, pg_atoi: error in " > > Sometimes it's followed by a number. I know this is caused because my > data files are windows text files - when I convert the files to UNIX > text files using UltraEdit32, it works fine (though I now have to > specify that empty strings are null values). I know that this problem > is specifically to do with the PostgreSQL - but I'm just curious if > anyone on this list knows of an easy fix that doesn't require > converting all my files...perhaps a setting in Cygwin or something > (I've already tried installing it with the DOS file setting, and I've > tried compiling PostgreSQL/PostGIS with all the fopen or popen > commands with the t argument for text). d2u part of the cygutils package might be easier then using an editor If that isn;t satisfactory I would try asking this question on the Cygwin PostgreSQL list mailto:pgsql-cygwin@postgresql.org Norman _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users