Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id BDEE819B908D for ; Tue, 8 May 2012 18:14:04 -0300 (ADT) Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SRrjM-00025W-77 for pgsql-docs@postgresql.org; Tue, 08 May 2012 21:14:03 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1SRrj7-0002kt-O7 for pgsql-docs@postgresql.org; Tue, 08 May 2012 17:13:45 -0400 Date: Tue, 8 May 2012 17:13:45 -0400 From: Bruce Momjian To: PostgreSQL-documentation Subject: NAME maximum length in _bytes_ Message-ID: <20120508211345.GK16882@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/7 X-Sequence-Number: 7332 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 NAMEDATALEN in C source code. Should I fix this? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +