"Missing" column in Postgres logical replication update message

2022-08-03 Thread Kevin Martin
We have a replication slot set up on a database in Postgres 12.8. For one of the tables, when a row is created, we see a series of records come through - an INSERT followed by a handful of UPDATEs. All of these messages in the WAL files show all columns, except for the last UPDATE message, which is

Re: "Missing" column in Postgres logical replication update message

2022-08-03 Thread Kevin Martin
My apologies. Read that in the mailing list instructions, and still forgot. Thanks for the reminder. On Wed, Aug 3, 2022 at 11:12 AM Adrian Klaver wrote: > On 8/3/22 08:09, Kevin Martin wrote: > > Please reply to list also > Ccing list > > I don't have answers to be

Re: "Missing" column in Postgres logical replication update message

2022-08-03 Thread Kevin Martin
Thanks for the response, Tom. I think that's exactly what's going on here. On Wed, Aug 3, 2022 at 11:28 AM Tom Lane wrote: > Adrian Klaver writes: > > On 8/3/22 08:09, Kevin Martin wrote: > >> I thought that any UPDATE message in the replication logs is designed