Re: psql \d+ and oid display

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, David Johnston <polobo(at)yahoo(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql \d+ and oid display
Date: 2014-04-09 04:21:11
Message-ID: CA+TgmoYnVocCVf4iPSrhYnyA=Sfna+hOWVuNhbjLE2t0BFsucA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Apr 8, 2014 at 5:37 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> On Tue, Apr 8, 2014 at 05:29:45PM -0400, Tom Lane wrote:
>> Bruce Momjian <bruce(at)momjian(dot)us> writes:
>> > If we ignore backward compatibility, then "Has OIDs" and "Identity
>> > Replica" are similar. One thing that strongly (for me) supports not
>> > always printing them is that I expect more people will be confused by
>> > the mention of OIDs or "Identity Replica" than will actually care about
>> > these features. For example, if we always printed "Child tables: 0",
>> > more people would be confused than helped.
>>
>> This is a good argument, actually: these fields are not only noise for
>> most people, but confusing if you don't know the feature they are
>> talking about.
>
> Let me put it this way: I didn't know what "Identity Replica" meant
> when I saw it in psql. Now, some might say that is expected, but still. ;-)

Well, that's sorta my concern. I mean, right now we've got people
saying "what the heck is a replica identity?". But, if the logical
decoding stuff becomes popular, as I hope it will, that's going to be
an important thing for people to adjust, and the information needs to
be present in a clear and easily-understood way. I haven't studied
the current code in detail so maybe it's fine. I just want to make
sure we're not giving it second-class treatment solely on the basis
that it's new and people aren't using it yet.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-04-09 04:23:43 Re: Call for GIST/GIN/SP-GIST opclass documentation
Previous Message Etsuro Fujita 2014-04-09 03:03:03 Re: Minor improvements in alter_table.sgml