Re: PostgreSQL logical decoder output plugin - unchanged toast data - Mailing list pgsql-hackers

From Georgy Buranov
Subject Re: PostgreSQL logical decoder output plugin - unchanged toast data
Date
Msg-id CAGMDm35NrfFsu=+pMs2Pqe-8s7tEWpd3y326g2Tm8cCa1y5pRg@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL logical decoder output plugin - unchanged toast data  (Andres Freund <andres@anarazel.de>)
Responses Re: PostgreSQL logical decoder output plugin - unchanged toast data  (Andres Freund <andres@anarazel.de>)
List 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 by date:

Previous
From: Sandeep Thakkar
Date:
Subject: Re: [HACKERS] git down
Next
From: Alexander Korotkov
Date:
Subject: Re: A strange GiST error message or fillfactor of GiST build