Heikki Linnakangas wrote:
I found the typo in
http://www.postgresql.org/docs/8.3/static/datatype-enum.html .

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.

Correct is that the NAMEDATALEN means 64 bytes in standard builds.

No. NAMEDATALEN is 64 bytes, but the 64th byte is reserved for the null-terminator, so the string stored can be at most 63 bytes long.

Ok.

But, it's described that NAMEDATALEN is 64 bytes in
http://www.postgresql.org/docs/8.3/static/sql-createtype.html.

This conflict can confuse the user. So, should we unite the
descriptions of the number of bytes for NAMEDATALEN?

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
TEL (03)5860-5115
FAX (03)5463-5490


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to