From: | Mike Leahy <mgleahy(at)fes(dot)uwaterloo(dot)ca> |
---|---|
To: | pgsql-cygwin(at)postgresql(dot)org |
Subject: | FW: [postgis-users] ": can't parse "ne 1, pg_atoi: error in " &empty strings in shp2pgsql output... |
Date: | 2003-09-14 16:19:52 |
Message-ID: | 1063556392.3f64952825ebe@www.nexusmail.uwaterloo.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
All,
On Norman's recommendation below, I'm forwarding this question to this list...
Kind regards,
Mike
-----Original Message-----
From: postgis-users-bounces(at)postgis(dot)refractions(dot)net [mailto:postgis-users-
bounces(at)postgis(dot)refractions(dot)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:
>
> Ive 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 its 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 doesnt require
> converting all my files...perhaps a setting in Cygwin or something
> (Ive already tried installing it with the DOS file setting, and Ive
> 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(at)postgresql(dot)org
Norman
_______________________________________________
postgis-users mailing list postgis-users(at)postgis(dot)refractions(dot)net
http://postgis.refractions.net/mailman/listinfo/postgis-users
----------------------------------------
This mail sent through www.mywaterloo.ca
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Tishler | 2003-09-15 02:37:01 | Re: postgres help[Scanned] |
Previous Message | Mike Leahy | 2003-09-14 16:09:36 | FW: [postgis-users] ": can't parse "ne 1, pg_atoi: error in " &empty strings in shp2pgsql output... |