Hello Euler, Thank you very for your prompt response.
I am really very sorry that I didn't mention about my exact question. So as you can see from my previous email, in the replication slot I see the value '*unchanged-toast-datum*' for the column of dataytpe '*character varying*'. Based on this, when I query my target PostgreSQL instance after the *UPDATE *statement is run, the value in this column gets changed to ' *unchanged-toast-datum*'. The steps that I gave is a simple reproduction and I would request you to please give that a try as well. Hence, my question is how can workaroud this issue or is there a resolution for this problem. Kindly review and please share your comments. Thanks and Regards, Abhinav Singh On Tue, Sep 26, 2017 at 6:25 PM, Euler Taveira <eu...@timbira.com.br> wrote: > 2017-09-26 1:11 GMT-03:00 Abhinav Singh <abhinav.theg...@gmail.com>: > > 5. On the target, when I do a select * and see that the column with > > character varying() datatype has changed to 'unchanged-toast-datum'. > > > The column "is_toast" didn't change its value to > "unchanged-toast-datum". It is just a test_decoding convention that > means that the value is stored in a TOAST table and it was not > changed. test_decoding doesn't show TOAST values to avoid performance > problems and to be brief. Try a SELECT in the table and you will see > that the value is already there. > > You didn't write an explicit question but I believe it was your doubt, > didn't it? > > > -- > Euler Taveira Timbira - > http://www.timbira.com.br/ > PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento >