From: Tom Lane <tgl@sss.pgh.pa.us>
To: Álvaro Herrera <alvherre@kurilemu.de>
Cc: Kirill Reshke <reshkekirill@gmail.com>
Cc: jian he <jian.universality@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt
Date: Fri, 22 Aug 2025 10:37:24 -0400
Message-ID: <1877555.1755873444@sss.pgh.pa.us> (raw)
In-Reply-To: <202508220946.osn274hnjxez@alvherre.pgsql>
References: <202508220946.osn274hnjxez@alvherre.pgsql>
=?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@kurilemu.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
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-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, alvherre@kurilemu.de, reshkekirill@gmail.com, jian.universality@gmail.com
Subject: Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt
In-Reply-To: <1877555.1755873444@sss.pgh.pa.us>
* 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