From: Álvaro Herrera <alvherre@kurilemu.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
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: Thu, 28 Aug 2025 18:23:46 +0200
Message-ID: <202508281623.awysrsga4r34@alvherre.pgsql> (raw)
In-Reply-To: <1885537.1755877852@sss.pgh.pa.us>
On 2025-Aug-22, Tom Lane wrote:
> Hmmm ... maybe something like
>
> Mathematically, a "relation" is a set of tuples; this is the sense
> meant in the term "relational database".
>
> In Postgres, "relation" is commonly used to mean a database object
> that has 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. A relation
> in this sense is a container or descriptor for a set of tuples.
>
> "Class" is an alternative but archaic term. The system catalog
> pg_class holds an entry for each Postgres relation.
Thanks, pushed like that. I changed "a database object" to "an SQL
object", because that's a term we have a definition for.
(I also wrote "PostgreSQL" where you had "Postgres". I think it might
be okay now to change the product name in various places here, but it
seems better to do it consistently across the whole page.)
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"¿Qué importan los años? Lo que realmente importa es comprobar que
a fin de cuentas la mejor edad de la vida es estar vivo" (Mafalda)
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: alvherre@kurilemu.de, tgl@sss.pgh.pa.us, reshkekirill@gmail.com, jian.universality@gmail.com
Subject: Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt
In-Reply-To: <202508281623.awysrsga4r34@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