Re: [HACKERS] How to read a value when it is VARATT EXTERNAL ONDISKfrom logical replication decoder

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] How to read a value when it is VARATT EXTERNAL ONDISKfrom logical replication decoder
Дата
Msg-id 20170220132428.oij7dmxamy66kler@alap3.anarazel.de
обсуждение исходный текст
Ответ на [HACKERS] How to read a value when it is VARATT EXTERNAL ONDISK from logicalreplication decoder  (Adam Dratwiński <adam.dratwinski@gmail.com>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Christoph Berg
Дата:
Сообщение: [HACKERS] powerpc(32) point/polygon regression failures on Debian Jessie
Следующее
От: Pavel Stehule
Дата:
Сообщение: [HACKERS] Error in XML recv function