pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedNAME maximum length in _bytes_
2+ messages / 1 participants
[nested] [flat]
* NAME maximum length in _bytes_
@ 2012-05-08 21:13 Bruce Momjian <bruce@momjian.us>
2012-05-10 22:45 ` Re: NAME maximum length in _bytes_ Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 2+ messages in thread
From: Bruce Momjian @ 2012-05-08 21:13 UTC (permalink / raw)
To: 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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: NAME maximum length in _bytes_
2012-05-08 21:13 NAME maximum length in _bytes_ Bruce Momjian <bruce@momjian.us>
@ 2012-05-10 22:45 ` Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2012-05-10 22:45 UTC (permalink / raw)
To: pgsql-docs
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
> <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. +
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-05-10 22:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-05-08 21:13 NAME maximum length in _bytes_ Bruce Momjian <bruce@momjian.us>
2012-05-10 22:45 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox