Обсуждение: BUG #18316: The descriptions of the objoid and classoid fields in the pg_description section, include: 12,14,16

Поиск
Список
Период
Сортировка
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."


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)