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

From Tatsuo Ishii
Subject Re: [HACKERS] REPLICA IDENTITY FULL
Date
Msg-id 20170620.114613.2176020532264476348.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: [HACKERS] REPLICA IDENTITY FULL  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] REPLICA IDENTITY FULL  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
>> 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.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] REPLICA IDENTITY FULL
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] REPLICA IDENTITY FULL