Re: PostgreSQL logical decoder output plugin - unchanged toast data

Поиск
Список
Период
Сортировка
От Georgy Buranov
Тема Re: PostgreSQL logical decoder output plugin - unchanged toast data
Дата
Msg-id CAGMDm35NrfFsu=+pMs2Pqe-8s7tEWpd3y326g2Tm8cCa1y5pRg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL logical decoder output plugin - unchanged toast data  (Andres Freund <andres@anarazel.de>)
Ответы Re: PostgreSQL logical decoder output plugin - unchanged toast data  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Hi Andres. Thank you very much for your help.

I tried the following solution and I have some problems.

* I have 9.6 postgres and I do not have separate field for rd_pkindex
* All I have is rd_replidindex field. Usually (when REPLICA IDENTITY
is NOT FULL), it still contains the primary key
* But in the case of REPLICA IDENTITY FULL - rd_replidindex is NULL
and rd_pkindex does not exist

So, is there a way to get the primary key on 9.6 postgres?

> If you want the pkey, that's in rd_pkindex. rd_replidindex will only
> differ if the identity is manually set to another candidate key
> (possibly because there's no pkey).
>


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

Предыдущее
От: Sandeep Thakkar
Дата:
Сообщение: Re: [HACKERS] git down
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: A strange GiST error message or fillfactor of GiST build