NAME maximum length in _bytes_
psql \dTS+ shows for data type 'name':
pg_catalog | name | name | 64 | |
| 63-character type for storing system identifiers
I believe this is really 63 bytes, not characters. I also see it
mismatched in our docs:
in the internal system catalogs and is not intended for use by the general user. Its
length is currently defined as 64 bytes (63 usable characters plus
----------
terminator) but should be referenced using the constant
<symbol>NAMEDATALEN</symbol> in <literal>C</> source code.
Should I fix this?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
On Tue, May 08, 2012 at 05:13:45PM -0400, Bruce Momjian wrote:
psql \dTS+ shows for data type 'name':
pg_catalog | name | name | 64 | |
| 63-character type for storing system identifiersI believe this is really 63 bytes, not characters. I also see it
mismatched in our docs:in the internal system catalogs and is not intended for use by the general user. Its
length is currently defined as 64 bytes (63 usable characters plus
----------
terminator) but should be referenced using the constant
<symbol>NAMEDATALEN</symbol> in <literal>C</> source code.Should I fix this?
Fix applied; no catalog bump.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +