From: | Álvaro Herrera <alvherre(at)kurilemu(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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-28 16:23:46 |
Message-ID: | 202508281623.awysrsga4r34@alvherre.pgsql |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Nathan Bossart | 2025-08-28 16:32:35 | Re: Improve LWLock tranche name visibility across backends |
Previous Message | Andres Freund | 2025-08-28 16:16:07 | Re: index prefetching |