Re: [patch] ENUM errdetail should mention bytes, not chars

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: [patch] ENUM errdetail should mention bytes, not chars
Дата
Msg-id CAOBaU_Z=nqiSGjtD_+bak61QLVwPuaibWg=WgcatdWWaDA4Jcg@mail.gmail.com
обсуждение исходный текст
Ответ на [patch] ENUM errdetail should mention bytes, not chars  (Ian Lawrence Barwick <barwick@gmail.com>)
Ответы Re: [patch] ENUM errdetail should mention bytes, not chars  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
On Mon, Oct 19, 2020 at 12:18 PM Ian Lawrence Barwick <barwick@gmail.com> wrote:
>
> Hi
>
> The errdetail emitted when creating/modifying an ENUM value is misleading:
>
>     postgres=# CREATE TYPE enum_valtest AS ENUM (
>                 'foo',
>                 'ああああああああああああああああああああああ'
>                );
>     ERROR:  invalid enum label "ああああああああああああああああああああああ"
>     DETAIL:  Labels must be 63 characters or less.
>
> Attached trivial patch changes the message to:
>
>     DETAIL:  Labels must be 63 bytes or less.
>
> This matches the documentation, which states:
>
>     The length of an enum value's textual label is limited by the NAMEDATALEN
>     setting compiled into PostgreSQL; in standard builds this means at most
>     63 bytes.
>
>     https://www.postgresql.org/docs/current/datatype-enum.html
>
> I don't see any particular need to backpatch this.

Indeed the message is wrong, and patch LGTM.



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

Предыдущее
От: Ian Lawrence Barwick
Дата:
Сообщение: [patch] ENUM errdetail should mention bytes, not chars
Следующее
От: Amit Langote
Дата:
Сообщение: Re: partition routing layering in nodeModifyTable.c