Re: COPY FROM is not 8bit clean

Поиск
Список
Период
Сортировка
От Darcy Buskermolen
Тема Re: COPY FROM is not 8bit clean
Дата
Msg-id 3.0.32.20020226082322.02cc2c30@mail.ok-connect.com
обсуждение исходный текст
Ответ на COPY FROM is not 8bit clean  (Darcy Buskermolen <darcy@ok-connect.com>)
Ответы Re: COPY FROM is not 8bit clean  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Postgres was not compiled with Multibyte, if I replace the if (delimc == c)
with if (strstr(delim,c)) it works as expected. This changes was
implemented for performance reasons according to the CVS log.



At 11:57 PM 2/25/02 -0500, Tom Lane wrote:
>Darcy Buskermolen <darcy@ok-connect.com> writes:
>> When useing COPY FROM 'file' DELIMITER '\254' copyfrom reads past the
>> delimiter and ends up with parse errors when trying to do the insert
>
>Are you perhaps operating in a multibyte encoding in which \254 is
>just the first byte of a multibyte character?
>
>I'm not sure what we do in such a case, and even less sure what we
>should do ... but I am entirely prepared to believe that we don't
>do the Right Thing ...
>
>            regards, tom lane
>
>

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug #604: string join problem
Следующее
От: Darcy Buskermolen
Дата:
Сообщение: Re: COPY FROM is not 8bit clean