Skip site navigation (1) Skip section navigation (2)

NAME maximum length in _bytes_

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: NAME maximum length in _bytes_
Date: 2012-05-08 21:13:45
Message-ID: 20120508211345.GK16882@momjian.us (view raw or flat)
Thread:
Lists: pgsql-docs
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(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

Responses

pgsql-docs by date

Next:From: Peter EisentrautDate: 2012-05-10 18:00:37
Subject: Re: Capitalization of 'TimeZone' GUC
Previous:From: Peter EisentrautDate: 2012-05-08 16:36:23
Subject: Re: misspellings & typofixes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group