| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Useless "Replica Identity: NOTHING" noise from psql \d |
| Date: | 2014-03-24 16:35:20 |
| Message-ID: | 20140324163520.GA9567@eldon.alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2014-03-24 17:39:54 | Re: HEAD seems to generate larger WAL regarding GIN index |
| Previous Message | Bruce Momjian | 2014-03-24 16:22:39 | Re: Useless "Replica Identity: NOTHING" noise from psql \d |