Thread: BUG #4109: Typo in documentation
The following bug has been logged online: Bug reference: 4109 Logged by: Fujii Masao Email address: fujii.masao@oss.ntt.co.jp PostgreSQL version: 8.3 Operating system: All Description: Typo in documentation Details: 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.
Fujii Masao wrote: > The following bug has been logged online: > > Bug reference: 4109 > Logged by: Fujii Masao > Email address: fujii.masao@oss.ntt.co.jp > PostgreSQL version: 8.3 > Operating system: All > Description: Typo in documentation > Details: > > 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. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
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
Fujii Masao wrote: > 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? The create_type.sgml file says: must be _less_ _than_ <symbol>NAMEDATALEN</symbol> bytes long so it seems consistent to me. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +