Re: Bug in psql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris BSomething <xpusostomos(at)gmail(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, PostgreSQL Bug List <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Bug in psql
Date: 2025-02-03 16:19:57
Message-ID: 403205.1738599597@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Chris BSomething <xpusostomos(at)gmail(dot)com> writes:
> Who exactly in user land is edified by referring to indexes as relations?

They're relations because they have pg_class and pg_attribute entries.
If the system catalogs were something that no user ever looked at,
maybe this would not matter; but that's not how business is done with
Postgres.

They're also relations because they have storage. (Admittedly, there
are relations that don't have storage, like views.) If we didn't
collect everything with storage under the term "relation", we'd need
some other term whenever we want to talk about physical files.

> Surely
> it's not beyond a moderately talented person to come up with something.

The trick is to come up with something that will garner a consensus
that it's an improvement. As mentioned already, feel free to make
a concrete proposal. Don't expect that somebody else will.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2025-02-03 17:03:32 BUG #18792: Segmentaion Fault error when changing new parameter synchronized_standby_slots
Previous Message Sachin Konde-Deshmukh 2025-02-03 13:59:43 Re: BUG #18789: logical replication slots are deleted after failovers