Re: psql \d+ and oid display - Mailing list pgsql-hackers

From David Johnston
Subject Re: psql \d+ and oid display
Date
Msg-id 1395953031372-5797707.post@n5.nabble.com
Whole thread Raw
In response to psql \d+ and oid display  (Bruce Momjian <bruce@momjian.us>)
Responses Re: psql \d+ and oid display  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Bruce Momjian wrote
> When we made OIDs optional, we added an oid status display to \d+:
> 
>     test=> \d+ test
>                              Table "public.test"
>      Column |  Type   | Modifiers | Storage | Stats target | Description
>     --------+---------+-----------+---------+--------------+-------------
>      x      | integer |           | plain   |              |
> -->    Has OIDs: no
> 
> Do we want to continue displaying that OID line, or make it optional for
> cases where the value doesn't match default_with_oids?

If we didn't make it behave this way at the time of the change then what has
changed that we should make it behave this way now?  I like the logic
generally but not necessarily the change.  

The disadvantage of this change is users (both end and tools) of the data
now also have to look at what the default is (or was at the time the text
was generated) to know what a suppressed OIDs means.  Given how much
information the typical \d+ generates I would suspect that the added noise
this introduces is quickly ignored by frequent users and not all the
disruptive to those who use \d+ infrequently.  Tools likely would prefer is
to be always displayed.

My $0.02

David J.




--
View this message in context: http://postgresql.1045698.n5.nabble.com/psql-d-and-oid-display-tp5797653p5797707.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Useless "Replica Identity: NOTHING" noise from psql \d
Next
From: Andrew Dunstan
Date:
Subject: Re: psql \d+ and oid display