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