Date: Tue, 7 May 2019 18:03:29 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>,
	Rafia Sabih <rafia.pghackers@gmail.com>,
	Justin Pryzby <pryzby@telsasoft.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: make \d pg_toast.foo show its indices
Message-ID: <20190507220329.GN6197@tamriel.snowman.net>
References: 
 <CA+FpmFfihB-okuPa0sxyhALpXcxMuHJYDS95sqvra6+D5Zkk6g@mail.gmail.com>
 <20190503142721.GC3925@telsasoft.com>
 <CA+FpmFffNcyO8CcG7O7P72K4-PuzataxT=hfWbaV=SrosMK=Cg@mail.gmail.com>
 <16689.1557158298@sss.pgh.pa.us>
 <20190507151600.GH6197@tamriel.snowman.net>
 <30641.1557242690@sss.pgh.pa.us>
 <20190507153006.GI6197@tamriel.snowman.net>
 <CA+TgmoaufnvnN7bp_xkefka+dL40nMe+j0uAfLELqDwu6y=G_Q@mail.gmail.com>
 <20190507204809.GM6197@tamriel.snowman.net>
 <3433.1557265781@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="Ror/Vc5Q6kDZ4GbZ"
Content-Disposition: inline
In-Reply-To: <3433.1557265781@sss.pgh.pa.us>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk


--Ror/Vc5Q6kDZ4GbZ
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Greetings,

* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Stephen Frost <sfrost@snowman.net> writes:
> > Having our test framework deny us useful features just strikes me as
> > bizarre.
>=20
> This is presuming that it's useful, which is debatable IMO.
> I think most people will find it useless noise almost all of the time.

Alright, maybe I'm not the best representation of our user base, but I
sure type 'select oid,* from pg_class where relname =3D ...' with some
regularity, mostly to get the oid to then go do something else.  Having
the relfilenode would be nice too, now that I think about it, and
reltuples.  There's ways to get *nearly* everything that's in pg_class
and friends out of various \d incantations, but not quite everything,
which seems unfortunate.

In any case, I can understand an argument that the code it requires is
too much to maintain for a relatively minor feature (though it hardly
seems like it would be...) or that it would be confusing or unhelpful to
users (aka "noise") much of the time, so I'll leave it to others to
comment on if they think any of these ideas be a useful addition or not.

I just don't think we should be voting down a feature because it'd take
a bit of extra effort to make our regression tests work with it, which
is all I was intending to get at here.

Thanks!

Stephen

--Ror/Vc5Q6kDZ4GbZ
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJc0gCxAAoJEO1sijiDR2RVO9EQAIg4korJIcNbkm/dxFf8jLS1
KC0ZBxwVuL/2hph53+x9U9phzTmicFlOJesn631N3T1/RnSQwWJx7o2asjDx2D4B
+V/fRv2UPw0FEzVTZlGKVlF3eogCatwS5DNKN71w1RLcCRP7fm+rYdBgfXDxcgre
lR+FTH3HGRCCgtYO2vzTURLZczbcV3NhHe1/fEmCwgCqqytPCiPV1dVizCew67L0
flFs1RVz7sfOUpMegZXtVVYNo7+kzygpU9RiWRY/CIc8keUz7+Wu3ArB177O7bn2
5NKPd7bFIvzGP1igd4KWG8zFZlfBit7Hucw6Cs3Hxugv9L+UFMCJgJIbXqXHAZ8n
4n9tP1XLiXR7ydmwBLeefwMohzwR54v7UAiYzW+vvQuoJf28qNdPqDMswfuPmXg2
asZu7myC5mgkz1WFw8T1B+FS0uwGJY+LJLPriMSjHlCmMGCdSL2bryAnUGgLinKL
LQEXBEbmAqlqWqxKsxOEpn/OAztQE6jxP1CRK98S4wvBbO0zcOhPB9VNtAZ6bkkD
XXTc6wFlvJL5sdVGOwBGdYCdONTEIlsQl6OAmqf43t6emrHfgRiLwdSbnY74+5Is
e5NpCmuD5HVrJvnI7lVALzuU/lJPuuP5LGtzFVNb0CGnG5J28Z9I/MQAwTqMh/l1
kIaoiZJbvgSk4Eiwsosr
=a5U+
-----END PGP SIGNATURE-----

--Ror/Vc5Q6kDZ4GbZ--