Re: Useless "Replica Identity: NOTHING" noise from psql \d - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Useless "Replica Identity: NOTHING" noise from psql \d
Date
Msg-id 20131214164336.GD3368@awork2.anarazel.de
Whole thread Raw
In response to Useless "Replica Identity: NOTHING" noise from psql \d  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Useless "Replica Identity: NOTHING" noise from psql \d
List pgsql-hackers
On 2013-12-14 11:27:53 -0500, Tom Lane wrote:
> In HEAD:
> 
> regression=# \d pg_depend
>    Table "pg_catalog.pg_depend"
>    Column    |  Type   | Modifiers 
> -------------+---------+-----------
>  classid     | oid     | not null
>  objid       | oid     | not null
>  objsubid    | integer | not null
>  refclassid  | oid     | not null
>  refobjid    | oid     | not null
>  refobjsubid | integer | not null
>  deptype     | "char"  | not null
> Indexes:
>     "pg_depend_depender_index" btree (classid, objid, objsubid)
>     "pg_depend_reference_index" btree (refclassid, refobjid, refobjsubid)
> Replica Identity: NOTHING
> 
> Where did that last line come from, and who thinks it's so important
> that it should appear by default?  It seems absolutely content-free
> even if I were using whatever feature it refers to, since it is
> (I presume) the default state.

Hm. Yes, that's slightly inellegant. It's shown because it's not
actually the normal default normal tables. Just for system tables. Maybe
we should just set it to default (in pg_class) for system tables as
well, and just change it in the relcache.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Useless "Replica Identity: NOTHING" noise from psql \d
Next
From: Robert Haas
Date:
Subject: Re: Changeset Extraction Interfaces