pg.ddx.io pgsql-docs@postgresql.org mailing list archive help / color / mirror / Atom feed From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: elionescu@yahoo.com
Subject: incorrect PostgreSQL documentation for pg_type
Date: Fri, 02 Aug 2024 14:14:36 +0000
Message-ID: <172260807672.915368.2735065255633424386@wrigleys.postgresql.org> (raw )
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/catalog-pg-type.html
Description:
Regarding https://www.postgresql.org/docs/12/catalog-pg-type.html
There is an error in the documentation, at least for version 12 (cannot
check for version 16), in the ‘References ‘ column, for the following
entries:
Table 51.63. pg_type Columns
Name Type References
---- ---- -----------
typinput regproc pg_proc.oid
typoutput regproc pg_proc.oid
typreceive regproc pg_proc.oid
typsend regproc pg_proc.oid
typmodin regproc pg_proc.oid
typmodout regproc pg_proc.oid
typanalyze regproc pg_proc.oid
The correct reference is pg_proc.proname
select VERSION();
PostgreSQL 12.14 on aarch64-unknown-linux-gnu, compiled by
aarch64-unknown-linux-gnu-gcc (GCC) 9.5.0, 64-bit
select * from pg_type where typname = 'varchar';
|oid
|typname|typnamespace|typowner|typlen|typbyval|typtype|typcategory|typispreferred|typisdefined|typdelim|typrelid|typelem|typarray|typinput
|typoutput |typreceive |typsend |typmodin |typmodout
|typanalyze|typalign|typstorage|typnotnull|typbasetype|typtypmod|typndims|typcollation|typdefaultbin|typdefault|typacl|
|-----|-------|------------|--------|------|--------|-------|-----------|--------------|------------|--------|--------|-------|--------|---------|----------|-----------|-----------|---------------|----------------|----------|--------|----------|----------|-----------|---------|--------|------------|-------------|----------|------|
|1,043|varchar|11 |10 |-1 |false |b |S
|false |true |, |0 |0 |1,015
|varcharin|varcharout|varcharrecv|varcharsend|varchartypmodin|varchartypmodout|-
|i |x |false |0 |-1 |0 |100
| | | |
select * from pg_proc where proname in ('varcharin', 'varcharout',
'varcharrecv', 'varcharsend', 'varchartypmodin', 'varchartypmodout');
|oid |proname
|pronamespace|proowner|prolang|procost|prorows|provariadic|prosupport|prokind|prosecdef|proleakproof|proisstrict|proretset|provolatile|proparallel|pronargs|pronargdefaults|prorettype|proargtypes|proallargtypes|proargmodes|proargnames|proargdefaults|protrftypes|prosrc
|probin|proconfig|proacl|
|-----|----------------|------------|--------|-------|-------|-------|-----------|----------|-------|---------|------------|-----------|---------|-----------|-----------|--------|---------------|----------|-----------|--------------|-----------|-----------|--------------|-----------|----------------|------|---------|------|
|1,046|varcharin |11 |10 |12 |1 |0 |0
|- |f |false |false |true |false |i
|s |3 |0 |1,043 |2275 26 23 |
| | | | |varcharin |
| | |
|1,047|varcharout |11 |10 |12 |1 |0 |0
|- |f |false |false |true |false |i
|s |1 |0 |2,275 |1043 |
| | | | |varcharout |
| | |
|2,915|varchartypmodin |11 |10 |12 |1 |0 |0
|- |f |false |false |true |false |i
|s |1 |0 |23 |1263 |
| | | | |varchartypmodin |
| | |
|2,916|varchartypmodout|11 |10 |12 |1 |0 |0
|- |f |false |false |true |false |i
|s |1 |0 |2,275 |23 |
| | | | |varchartypmodout|
| | |
|2,432|varcharrecv |11 |10 |12 |1 |0 |0
|- |f |false |false |true |false |s
|s |3 |0 |1,043 |2281 26 23 |
| | | | |varcharrecv |
| | |
|2,433|varcharsend |11 |10 |12 |1 |0 |0
|- |f |false |false |true |false |s
|s |1 |0 |17 |1043 |
| | | | |varcharsend |
| | |
view thread (3+ messages) latest in thread
Message-ID: <172260807672.915368.2735065255633424386@wrigleys.postgresql.org>
Permalink: ../172260807672.915368.2735065255633424386@wrigleys.postgresql.org/
Also on: postgresql.org/message-id/172260807672.915368.2735065255633424386@wrigleys.postgresql.org
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, elionescu@yahoo.com
Subject: Re: incorrect PostgreSQL documentation for pg_type
In-Reply-To: <172260807672.915368.2735065255633424386@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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