Feedback-ID: ia2694551:Fastmail
Date: Wed, 31 Jan 2024 11:19:33 +0100
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: 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
Message-ID: <202401311019.tks4hnuzi7dd@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <18316-9fce4e053fd270dc@postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/202401311019.tks4hnuzi7dd%40alvherre.pgsql>
Precedence: bulk

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)