Bug #762: copy table from '/home/postgres/import' using delimiters ',' errors on first line. - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #762: copy table from '/home/postgres/import' using delimiters ',' errors on first line.
Date
Msg-id 20020909195215.367A9475EAA@postgresql.org
Whole thread Raw
Responses Re: Bug #762: copy table from '/home/postgres/import' using  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-bugs
Jeff Post (postjeff@uwm.edu) reports a bug with a severity of 4
The lower the number the more severe it is.

Short Description
copy table from '/home/postgres/import' using delimiters ',' errors on first line.

Long Description
When I attempt to populate an empty table using copy from (specificaly while using a comma as the delimiter) I recieve
anatoi error on the first row and the copy fails. If I add a comma to the end of the first row, I get a warning message
aboutextra fields being ignored and the copy completes successfuly. 

The file I am using to copy from is generated by an oracle application that is saved onto a windows desktop and ftp'd
tothe linux machine running PostgreSQL. 

any help is greatly appreciated.

Jeff Post

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: ecpg hackery to get ecpg to compile from FreeBSD ports...
Next
From: Tom Lane
Date:
Subject: Re: _bt_check_unique checks every row in table when doing update??