From: Tom Lane <tgl@sss.pgh.pa.us>
To: Chris BSomething <xpusostomos@gmail.com>
cc: "David G. Johnston" <david.g.johnston@gmail.com>,
        PostgreSQL Bug List <pgsql-bugs@lists.postgresql.org>
Subject: Re: Bug in psql
In-reply-to: 
 <CADrHaBHPmbUXXYyHgcaC6poEWbsLnVxd3vCBQZw+NB72iCJ9ow@mail.gmail.com>
References: 
 <CADrHaBEVSYwemoJWtry2+82KHy9tZirH2PVfi-uD96R5J8FCsw@mail.gmail.com>
 <CAKFQuwYawZ=80oP4P8qDWA-YxtKQK_QVnVvH-OQE25benc9SQQ@mail.gmail.com>
 <CADrHaBF91oNdNe1JUP6-L+KnRtj_o_C-V63KEo5o4Uufdr2KzQ@mail.gmail.com>
 <CAKFQuwbwgYmZEEfJL7PFGGKNiCX6rTPyVLv8VDYpeQKGpdCcDg@mail.gmail.com>
 <CADrHaBHPmbUXXYyHgcaC6poEWbsLnVxd3vCBQZw+NB72iCJ9ow@mail.gmail.com>
Comments: In-reply-to Chris BSomething <xpusostomos@gmail.com>
	message dated "Mon, 03 Feb 2025 20:29:57 +0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <403204.1738599597.1@sss.pgh.pa.us>
Date: Mon, 03 Feb 2025 11:19:57 -0500
Message-ID: <403205.1738599597@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/403205.1738599597%40sss.pgh.pa.us>
Precedence: bulk

Chris BSomething <xpusostomos@gmail.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