Bruce Momjian wrote:
> On Wed, Mar 26, 2014 at 12:20:07PM -0300, Alvaro Herrera wrote:
> > Not opposed to this, but it seems a bit strange; REPLICA IDENTITY is a
> > property of the table, not of any individual index. I think we should
> > lose the token in the "Indexes" section.
>
> That is an interesting idea. It would mean that \d table would not show
> anything about replica identity, because right now it does:
>
> test=> \d test
> Table "public.test"
> Column | Type | Modifiers
> --------+---------+-----------
> x | integer | not null
> Indexes:
> "test_pkey" PRIMARY KEY, btree (x) REPLICA IDENTITY
>
> That seems logical.
Hmm. It seems to me that to make this more compact we could keep the
current token in the index line if it's INDEX, and not display the
Replica Identity: line at all; and if it's something other than index
and different from the default value, then print "Replica Identity" in
both \d and \d+.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services