Re: COPY alloc problem in 7.4

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: COPY alloc problem in 7.4
Дата
Msg-id 878ym0kw7i.fsf@mailbox.samurai.com
обсуждение исходный текст
Ответ на COPY alloc problem in 7.4  (Margus Väli <mvali@hot.ee>)
Ответы Re: COPY alloc problem in 7.4
Список pgsql-bugs
Margus Väli <mvali@hot.ee> writes:
> COPY command tries to create a buffer too large in size when the
> file copied is larger than about 500 bytes.

Can anyone else reproduce this? I did the following with a fairly
recent CVS snapshot:

    1. Copied the supplied text data to a file, fixed up the extra
       newlines so that COPY doesn't bail out

    2. Created a new database with encoding = unicode

    3. Create a table "marksona" in that DB with the supplied schema

    4. I then got the following:

unicode_test=# copy marksona from '/home/nconway/copy_input.asc' with delimiter '|' null as '';
ERROR:  Unicode characters greater than or equal to 0x10000 are not supported
CONTEXT:  COPY marksona, line 12, column sona: "Balti Sõjaväeringkonna Ülemjuh"

    5. If I load the data into a SQL_ASCII encoded DB, the COPY
       command succeeds.

However, I know absolutely nothing about Unicode, so perhaps I've
mucked something up.

-Neil

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Some troubles from Postgrres_beta4
Следующее
От: Neil Conway
Дата:
Сообщение: Re: Problem using LIMIT 1 when only 1 record exists.