Re: Bug in COPY FROM backslash escaping multi-byte chars

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Bug in COPY FROM backslash escaping multi-byte chars
Дата
Msg-id fb716ba3-b3e4-8d6c-cbfd-283be980ae42@iki.fi
обсуждение исходный текст
Ответ на Re: Bug in COPY FROM backslash escaping multi-byte chars  (John Naylor <john.naylor@enterprisedb.com>)
Ответы Re: Bug in COPY FROM backslash escaping multi-byte chars
Список pgsql-hackers
On 03/02/2021 15:38, John Naylor wrote:
> On Wed, Feb 3, 2021 at 8:08 AM Heikki Linnakangas <hlinnaka@iki.fi 
> <mailto:hlinnaka@iki.fi>> wrote:
>  >
>  > Hi,
>  >
>  > While playing with COPY FROM refactorings in another thread, I noticed
>  > corner case where I think backslash escaping doesn't work correctly.
>  > Consider the following input:
>  >
>  > \么.foo
> 
> I've seen multibyte delimiters in the wild, so it's not as outlandish as 
> it seems.

We don't actually support multi-byte characters as delimiters or quote 
or escape characters:

postgres=# copy copytest from 'foo' with (delimiter '么');
ERROR:  COPY delimiter must be a single one-byte character

> The fix is simple enough, so +1.

Thanks, I'll commit and backpatch shortly.

- Heikki



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

Предыдущее
От: John Naylor
Дата:
Сообщение: Re: Bug in COPY FROM backslash escaping multi-byte chars
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: libpq debug log