Re: Bug #762: copy table from '/home/postgres/import' using

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Bug #762: copy table from '/home/postgres/import' using
Дата
Msg-id 20020909135238.O16355-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Bug #762: copy table from '/home/postgres/import' using delimiters ',' errors on first line.  (pgsql-bugs@postgresql.org)
Список pgsql-bugs
On Mon, 9 Sep 2002 pgsql-bugs@postgresql.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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: _bt_check_unique checks every row in table when doing update??
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Unable to compile 7.3beta1 on cygwin