Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: Kirill Reshke <reshkekirill(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt
Date: 2025-08-22 14:37:24
Message-ID: 1877555.1755873444@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

=?utf-8?Q?=C3=81lvaro?= Herrera <alvherre(at)kurilemu(dot)de> writes:
> I'm not sure. See the definition of relation in the glossary:
> https://www.postgresql.org/docs/18/glossary.html#GLOSSARY-RELATION

> The generic term for all objects in a database that have a name and a
> list of attributes defined in a specific order. Tables, sequences,
> views, foreign tables, materialized views, composite types, and
> indexes are all relations.

> More generically, a relation is a set of tuples; for example, the
> result of a query is also a relation.

> In PostgreSQL, Class is an archaic synonym for relation.

> (I wonder why this says "generically" rather than "generally". Is that
> word choice a mistake?) Maybe in the "For example" clause we can also
> mention table functions.

Yeah, I think s/generically/generally/ would be an improvement.

I'm not certain, but I think that our use of "relation" to mean
"an object with a pg_class entry" is a Postgres-ism. I do know
that the meaning of "a set of tuples" is widely used, as that's
where the term "relational database" comes from. Maybe whoever
wrote this was trying to get at that point? But this text is
hardly clear about that.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Benoit T 2025-08-22 14:58:16 Re: pg_stat_statements: Add `calls_aborted` counter for tracking query cancellations
Previous Message Richard Guo 2025-08-22 14:19:49 Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt