From: Stephen Frost <sfrost@snowman.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Rafia Sabih <rafia.pghackers@gmail.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: make \d pg_toast.foo show its indices
Date: Tue, 7 May 2019 18:03:29 -0400
Message-ID: <20190507220329.GN6197@tamriel.snowman.net> (raw)
In-Reply-To: <3433.1557265781@sss.pgh.pa.us>
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>
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.
>
> 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 = ...' 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
Attachments:
[application/pgp-signature] signature.asc (818B, ../20190507220329.GN6197@tamriel.snowman.net/2-signature.asc)
download
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: sfrost@snowman.net, tgl@sss.pgh.pa.us, robertmhaas@gmail.com, rafia.pghackers@gmail.com, pryzby@telsasoft.com
Subject: Re: make \d pg_toast.foo show its indices
In-Reply-To: <20190507220329.GN6197@tamriel.snowman.net>
* 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