Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 5B41714FB14 for ; Thu, 10 May 2012 19:45:51 -0300 (ADT) Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SSc7K-000553-FP for pgsql-docs@postgresql.org; Thu, 10 May 2012 22:45:51 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1SSc77-0003Mi-Tl for pgsql-docs@postgresql.org; Thu, 10 May 2012 18:45:37 -0400 Date: Thu, 10 May 2012 18:45:37 -0400 From: Bruce Momjian To: PostgreSQL-documentation Subject: Re: NAME maximum length in _bytes_ Message-ID: <20120510224537.GE16881@momjian.us> References: <20120508211345.GK16882@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20120508211345.GK16882@momjian.us> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/9 X-Sequence-Number: 7334 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 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? Fix applied; no catalog bump. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +