| From: | "Detlef Plotzky" <plo(at)bvu(dot)de> |
|---|---|
| To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Bug with SQL-COPY in 7.2 |
| Date: | 2002-02-15 14:07:16 |
| Message-ID: | 200202151407.g1FE7Gv24878@apollo.bvu.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi,
trying to import an ascii file with the sql copy statement
fails in the pg_atoi routine
if the last field is "int"
and
if the ascii file has DOS line endings (cr=0x0d and lf=0x0a).
The main problem is the error message: you cannot detect
the cr on the screen, you see only a "unknown" error.
Example of sql session:
shell> psql testdb postgres
testdb=# \d telefon
Table "telefon"
Column | Type | Modifiers
--------+------------------------+-----------
name | character varying(255) |
nr | character varying(63) |
email | character varying(63) |
dummy | integer |
testdb=# copy telefon from '/tmp/tel.asc' delimiters '|' ;
": can't parse "ne 1, pg_atoi: error in "12345
testdb=#\q
The data file tel.asc of the example is packed in the zip file
in the attachment.
Kind regards
Detlef
| Attachment | Content-Type | Size |
|---|---|---|
| ascii.zip | application/x-zip-compressed | 216 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-02-15 15:21:52 | Re: Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name |
| Previous Message | pgsql-bugs | 2002-02-15 12:06:07 | Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name |