Re: How to read a value when it is VARATT EXTERNAL ONDISK from logical replication decoder

From: Andres Freund <andres(at)anarazel(dot)de>
To: Adam Dratwiński <adam(dot)dratwinski(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to read a value when it is VARATT EXTERNAL ONDISK from logical replication decoder
Date: 2017-02-20 13:24:28
Message-ID: 20170220132428.oij7dmxamy66kler@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2017-02-20 11:44:58 +0100, Adam Dratwiński wrote:
> Hello everyone,
>
> I am writing a custom logical replication decoder, and I took test decoder
> from Postgres sources as an example.
>
> Could anyone tell me how to read "unchanged toast datum" in case it is
> VARTT_IS_EXTERNAL_ONDISK.

You can't by default. It's simply not available data - we'd have to log
a lot more data to make that fully available. If you change the replica
identity settings to FULL, the full old data (including toasted data)
will be logged.

Regards,

Andres

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2017-02-20 13:40:26 Error in XML recv function
Previous Message Christoph Berg 2017-02-20 12:51:50 powerpc(32) point/polygon regression failures on Debian Jessie