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

From Alvaro Herrera
Subject Re: Useless "Replica Identity: NOTHING" noise from psql \d
Date
Msg-id 20140324163520.GA9567@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: Useless "Replica Identity: NOTHING" noise from psql \d  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Useless "Replica Identity: NOTHING" noise from psql \d  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian wrote:
> On Mon, Mar 24, 2014 at 05:06:25PM +0100, Andres Freund wrote:
> > On 2014-03-22 23:47:57 -0400, Bruce Momjian wrote:
> > >     test=> \d+ test
> > >                              Table "public.test"
> > >      Column |  Type   | Modifiers | Storage | Stats target | Description
> > >     --------+---------+-----------+---------+--------------+-------------
> > >      x      | integer |           | plain   |              |
> > >     Replica Identity: full
> > >     Has OIDs: no
> > > 
> > > I used lower-case for the value, rather than all-caps.
> > 
> > Why? CLUSTER, PRIMARY KEY, etc. are displayed all caps, and replica
> > identity is similarly set via ALTER TABLE ... REPLICA IDENITY?
> 
> Oh, good points;  I had not considered PRIMARY KEY.  Updated patch
> attached.

In the "INDEX" case, should the output mention specifically which index
is being considered?



-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Useless "Replica Identity: NOTHING" noise from psql \d
Next
From: Heikki Linnakangas
Date:
Subject: Re: HEAD seems to generate larger WAL regarding GIN index