Re: [HACKERS] REPLICA IDENTITY FULL - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [HACKERS] REPLICA IDENTITY FULL
Date
Msg-id 20170620024706.ceyce2yoauxqpxyo@alap3.anarazel.de
Whole thread Raw
In response to Re: [HACKERS] REPLICA IDENTITY FULL  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: [HACKERS] REPLICA IDENTITY FULL
List pgsql-hackers
On 2017-06-20 11:46:13 +0900, Tatsuo Ishii wrote:
> >> Yes, that's my understanding too. However, the feature may or may not
> >> work depending on the data types of columns, probably I will not
> >> recommend users/my customers to use it.
> > 
> > I'm not sure how datatypes are playing into this?
> 
> For example, if the table consists of only INT types, REPLICA IDENTITY
> FULL works with UPDATE/DELETE (i.e. replicated), but if some of them
> are TEXT types, then UPDATE/DELETE does not work.
> 
> See up thread for more details.

Right, but that's just a bug, nothing else.



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] REPLICA IDENTITY FULL
Next
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] REPLICA IDENTITY FULL