Re: psql \d+ and oid display

From: Euler Taveira <euler(at)timbira(dot)com(dot)br>
To: Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: psql \d+ and oid display
Date: 2014-03-27 18:26:09
Message-ID: 53346D41.5020803@timbira.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 27-03-2014 10:15, 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?
>
That line is still important for those tables that have oids. Once a
while I see "with oids" set (mainly by mistake or misinformation).

The 8.0 (last version that have default_with_oids = on) is dead for more
than 3 years. Is it time to remove the d_w_o or even announce to remove
it in 2 releases?

Regarding to remove the "Has OIDs" line, it seems that it is just noise
since almost all tables does not have oids. However, if you remove
that line you'll have to fix the regression tests and also can break
third part extensions that use \d+ (we can live with that). If we agree
to remove d_w_o, don't worry with that line because it will be removed soon.

--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2014-03-27 18:54:26 Re: psql \d+ and oid display
Previous Message Noah Misch 2014-03-27 17:52:19 Re: Useless "Replica Identity: NOTHING" noise from psql \d