Re: REPLICA IDENTITY FULL

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Cc: craig(at)2ndquadrant(dot)com, peter(dot)eisentraut(at)2ndquadrant(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: REPLICA IDENTITY FULL
Date: 2017-06-20 02:47:06
Message-ID: 20170620024706.ceyce2yoauxqpxyo@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2017-06-20 02:52:10 Re: REPLICA IDENTITY FULL
Previous Message Tatsuo Ishii 2017-06-20 02:46:13 Re: REPLICA IDENTITY FULL