From: Collin F. Lynch <clynch@water2.cs.umass.edu>
To: pgsql-hackers@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: "20L" not interpreted as text.
Date: Thu, 12 Aug 1999 10:38:15 -0400 (EDT)
Message-ID: <199908121438.KAA03599@water2.cs.umass.edu> (raw)
Greetings, I'm having a peculiar problem that I seem unable to work my way around.
using pgtclsh I am attempting to load a file into postgres using the copy command specifically;
copy SensorDagta from '...../TempFile.txt' using delimiters '|';
the lines of the file themselves are:
4/21/99|859717.0|1.8|63|1|1.0|4.5|75.9|12:27:54|00|1|181.7|8500873.9|715513.1|181.1|8500873.9|71
5513.1|"20L"
4/21/99|859721.0|1.8|63|1|1.0|4.5|75.9|12:27:54|00|0|181.7|8500873.9|715513.1|181.1|8500873.9|71
5513.1|"20L"
etc.
The key problem is that whenever this command is executed I receive a
POSTGRES_FATAL_ERROR from the database and am informed that pg_atoi failed on the L in 20L. I
have already tested replacing the "" around 20L with single quotes and nothing, no difference is
made. The SensorData table itself defines the last column as type text. Oddly enough whenever
I attempt to execute the same command from within psql I have no problems. However when I
attempt to execute psql with a -c command the same error occurs. Is there some way to suppress
this? I am attemting to simplify the act of loading data for my colleagues and the extra hoops
are somewhat undesireable.
Thanks in advance.
Collin Lynch.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: clynch@water2.cs.umass.edu, pgsql-hackers@postgresql.org
Subject: Re: "20L" not interpreted as text.
In-Reply-To: <199908121438.KAA03599@water2.cs.umass.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox