Re: bogus: logical replication rows/cols combinations
Peter Eisentraut <peter.eisentraut@enterprisedb.com>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>,
Amit Kapila <amit.kapila16@gmail.com>
Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>,
Pg Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-04-28T12:13:25Z
Lists: pgsql-hackers
On 27.04.22 11:53, Alvaro Herrera wrote: > Now, another possibility is to say "naah, this is too hard", or even > "naah, there's no time to write all that for this release". That might > be okay, but in that case let's add an implementation restriction to > ensure that we don't paint ourselves in a corner regarding what is > reasonable behavior. For example, an easy restriction might be: if a > table is in multiple publications with mismatching row filters/column > lists, then a subscriber is not allowed to subscribe to both > publications. (Maybe this restriction isn't exactly what we need so > that it actually implements what we need, not sure). Then, if/when in > the future we implement this correctly, we can lift the restriction. My feeling is also that we should prohibit the combinations that we cannot make work correctly.
Commits
-
Prohibit combining publications with different column lists.
- fd0b9dcebda7 15.0 landed
-
Extend pg_publication_tables to display column list and row filter.
- 0ff20288e1cb 15.0 landed
-
Remove dynamic_shared_memory_type=none
- bcbd940806a2 12.0 cited