Re: psql \d+ and oid display

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: psql \d+ and oid display
Дата
Msg-id 1395953031372-5797707.post@n5.nabble.com
обсуждение исходный текст
Ответ на psql \d+ and oid display  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: psql \d+ and oid display  (Andrew Dunstan <andrew@dunslane.net>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Useless "Replica Identity: NOTHING" noise from psql \d
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: psql \d+ and oid display