From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: 865229936@qq.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18316: The descriptions of the objoid and classoid fields in the pg_description section, include: 12,14,16
Date: Wed, 31 Jan 2024 11:19:33 +0100
Message-ID: <202401311019.tks4hnuzi7dd@alvherre.pgsql> (raw)
In-Reply-To: <18316-9fce4e053fd270dc@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)
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-bugs@postgresql.org
Cc: alvherre@alvh.no-ip.org, 865229936@qq.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18316: The descriptions of the objoid and classoid fields in the pg_description section, include: 12,14,16
In-Reply-To: <202401311019.tks4hnuzi7dd@alvherre.pgsql>
* 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