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 > to > >> include all values fo

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

2022-08-03 Thread Tom Lane
Adrian Klaver writes: > On 8/3/22 08:09, Kevin Martin wrote: >> I thought that any UPDATE message in the replication logs is designed to >> include all values for all columns.  Is that correct? Buried deep in the wire protocol specification is this bit: The following message parts are shar

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

2022-08-03 Thread Kevin Martin
ed to include all columns. But I can't > > find a > > > definitive answer on that. > > > > > > So, my first question is: Is it normal / expected for UPDATE > > messages in > > > the replication logs to exclude any columns in the

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

2022-08-03 Thread Adrian Klaver
hanks. > > -Kevin > > > FYI.  I have this question posted also on StackOverflow: > https://stackoverflow.com/questions/73222107/missing-column-in-postgres-logical-replication-update-message <https://stackoverflow.com/questions/73222107/missing-column

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

2022-08-03 Thread Adrian Klaver
ed also on StackOverflow: https://stackoverflow.com/questions/73222107/missing-column-in-postgres-logical-replication-update-message <https://stackoverflow.com/questions/73222107/missing-column-in-postgres-logical-replication-update-message> -- Adrian Klaver adrian.kla...@aklaver.com

"Missing" column in Postgres logical replication update message

2022-08-03 Thread Kevin Martin
ve to hear any thoughts on what may cause it. Thanks. -Kevin FYI. I have this question posted also on StackOverflow: https://stackoverflow.com/questions/73222107/missing-column-in-postgres-logical-replication-update-message