| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | <postjeff(at)uwm(dot)edu>, <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Bug #762: copy table from '/home/postgres/import' using |
| Date: | 2002-09-09 20:53:48 |
| Message-ID: | 20020909135238.O16355-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, 9 Sep 2002 pgsql-bugs(at)postgresql(dot)org wrote:
> Long Description
> When I attempt to populate an empty table using copy from (specificaly
> while using a comma as the delimiter) I recieve an atoi 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 about extra 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 to the linux machine
> running PostgreSQL.
Are you perhaps running into an end of line difference problem? You
probably are getting CRLF vs LF.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-09-10 01:50:31 | Re: Unable to compile 7.3beta1 on cygwin |
| Previous Message | Tom Lane | 2002-09-09 20:21:50 | Re: _bt_check_unique checks every row in table when doing update?? |