COPY fails on 8.1 with invalid byte sequences in text types

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема COPY fails on 8.1 with invalid byte sequences in text types
Дата
Msg-id 1161985361.31124.139.camel@dogma.v10.wvs
обсуждение исходный текст
Ответы Re: COPY fails on 8.1 with invalid byte sequences in text  (Jeff Davis <pgsql@j-davis.com>)
Re: COPY fails on 8.1 with invalid byte sequences in text  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-bugs
You can insert invalid UTF8 bytes sequences into a TEXT type on an 8.1
installation by doing something like:

INSERT INTO foo(t) VALUES('\xFF');

Then, you can do a:

COPY foo TO '/some/file';

but if you try to do a:

COPY foo FROM '/some/file';

That will fail because /some/file contains invalid UTF8 sequences, even
though it's the same file you copied out.

It seems to be essentially a data corruption issue if applications
insert binary data in text fields using escape sequences. Shouldn't
PostgreSQL reject an invalid UTF8 sequence in any text type?

Regards,
    Jeff Davis

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #2724: Could not check connection status with "ssl=on"
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: COPY fails on 8.1 with invalid byte sequences in text