From: Erik Wienhold <ewie@ewie.name>
To: mdixon@plymouth.ac.uk
To: pgsql-docs@lists.postgresql.org
Subject: Re: Correction: Postgres emum documentation 8.7.4 should read 63 characters (instead of bytes)
Date: Sun, 2 Apr 2023 14:10:58 +0200 (CEST)
Message-ID: <1033607900.522472.1680437458038@office.mailbox.org> (raw)
In-Reply-To: <168030103185.632.13669298104803390697@wrigleys.postgresql.org>
References: <168030103185.632.13669298104803390697@wrigleys.postgresql.org>
> On 01/04/2023 00:17 CEST PG Doc comments form <noreply@postgresql.org> wrote:
>
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/15/datatype-enum.html
> Description:
>
> Postgres documentation, section 8.7.4 gives the limit on enum labels as 63
> bytes.
> Testing this with an oversized string gives the following error:
> SQL Error [42602]: ERROR: invalid enum label
> Detail: Labels must be 63 characters or less.
The documentation is correct. NAMEDATALEN is in bytes not characters.
The error message was fixed to say bytes in v14.
https://www.postgresql.org/message-id/flat/CAB8KJ%3DitZEJ7C9BacTHSYgeUysH4xx8wDiOnyppnSLyn6-g%2BBw%4...
--
Erik
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: ewie@ewie.name, mdixon@plymouth.ac.uk, pgsql-docs@lists.postgresql.org
Subject: Re: Correction: Postgres emum documentation 8.7.4 should read 63 characters (instead of bytes)
In-Reply-To: <1033607900.522472.1680437458038@office.mailbox.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox