Re: Useless "Replica Identity: NOTHING" noise from psql \d

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Useless "Replica Identity: NOTHING" noise from psql \d
Дата
Msg-id 20140326151258.GB23012@momjian.us
обсуждение исходный текст
Ответ на Re: Useless "Replica Identity: NOTHING" noise from psql \d  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Useless "Replica Identity: NOTHING" noise from psql \d  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On Mon, Mar 24, 2014 at 09:07:07PM -0400, Bruce Momjian wrote:
> > In the "INDEX" case, should the output mention specifically which index
> > is being considered?
>
> Ah, good idea.  Updated patch attached.  The output is now:
>
>     test=> \d+ test
>                              Table "public.test"
>      Column |  Type   | Modifiers | Storage | Stats target | Description
>     --------+---------+-----------+---------+--------------+-------------
>      x      | integer | not null  | plain   |              |
>     Indexes:
>         "test_pkey" PRIMARY KEY, btree (x) REPLICA IDENTITY
>         "i_test2" btree (x)
> -->    Replica Identity: USING INDEX "test_pkey"
>     Has OIDs: no
>
> However, now that I look at it, it seems redundant as REPLICA IDENTITY
> is already marked on the actual index.  Ideas?

Hearing nothing, I have gone back to the previous patch that just marks
replica identity as USING INDEX;  applied patch attached.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dang Minh Huong
Дата:
Сообщение: Duplicated row after promote in synchronous streaming replication
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Duplicated row after promote in synchronous streaming replication