pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18316: The descriptions of the objoid and classoid fields in the pg_description section, include: 12,14,16
2+ messages / 2 participants
[nested] [flat]
* BUG #18316: The descriptions of the objoid and classoid fields in the pg_description section, include: 12,14,16
@ 2024-01-31 02:29 PG Bug reporting form <noreply@postgresql.org>
2024-01-31 10:19 ` Re: BUG #18316: The descriptions of the objoid and classoid fields in the pg_description section, include: 12,14,16 Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2024-01-31 02:29 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: 865229936@qq.com
The following bug has been logged on the website:
Bug reference: 18316
Logged by: Yang MingGuo
Email address: 865229936@qq.com
PostgreSQL version: 14.10
Operating system: CentOS7
Description:
The descriptions of the objoid and classoid fields in the documentation's
pg_description section are misunderstood. The description for objoid should
reference pg_class.oid, and the description for classoid should specify the
OID of pg_class, rather than "pg_class.oid."
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18316: The descriptions of the objoid and classoid fields in the pg_description section, include: 12,14,16
2024-01-31 02:29 BUG #18316: The descriptions of the objoid and classoid fields in the pg_description section, include: 12,14,16 PG Bug reporting form <noreply@postgresql.org>
@ 2024-01-31 10:19 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 0 replies; 2+ messages in thread
From: Alvaro Herrera @ 2024-01-31 10:19 UTC (permalink / raw)
To: 865229936@qq.com; pgsql-bugs@lists.postgresql.org
On 2024-Jan-31, PG Bug reporting form wrote:
> The descriptions of the objoid and classoid fields in the documentation's
> pg_description section are misunderstood. The description for objoid should
> reference pg_class.oid, and the description for classoid should specify the
> OID of pg_class, rather than "pg_class.oid."
Hmm, no, that's not right. classid is supposed to refer to the
pg_class.oid value of the object type being commented on -- if you
comment on a table/view/etc then it's going to be the OID of pg_class.
But if you comment on a function, it's going to be the OID of pg_proc,
and so on.
As for objoid, that one is going to refer to the OID of the object being
commented on -- again, pg_class.oid if you are commenting on a
table/view/etc, but it could be pg_proc.oid if you're commenting on a
function, etc.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"¿Cómo puedes confiar en algo que pagas y que no ves,
y no confiar en algo que te dan y te lo muestran?" (Germán Poo)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-01-31 10:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-01-31 02:29 BUG #18316: The descriptions of the objoid and classoid fields in the pg_description section, include: 12,14,16 PG Bug reporting form <noreply@postgresql.org>
2024-01-31 10:19 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
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