Re: Column Filtering in Logical Replication

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, Rahila Syed <rahilasyed90(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Column Filtering in Logical Replication
Date: 2022-01-11 18:52:22
Message-ID: 202201111852.sg6v76xr6qkh@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 2022-Jan-10, Alvaro Herrera wrote:

> Hmm. So you're saying that we should only raise errors about the column
> list if we are publishing UPDATE or DELETE, but otherwise let the
> replica identity be anything. OK, I'll see if I can come up with a
> reasonable set of rules ...

This is an attempt to do it that way. Now you can add a table to a
publication without regards for how column filter compares to the
replica identity, as long as the publication does not include updates
and inserts.

Álvaro Herrera Valdivia, Chile —
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)

Attachment Content-Type Size
v17-0001-Support-column-lists-for-logical-replication-of-.patch text/x-diff 80.9 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Laurenz Albe 2022-01-11 18:59:13 Re: [PATCH] Add reloption for views to enable RLS
Previous Message Tomas Vondra 2022-01-11 18:47:00 Re: sequences vs. synchronous replication