Hi,
Thank you for developing of the great feature.
If multiple tables are specified when creating a PUBLICATION,
is it supposed that the WHERE clause condition is given to only one table?
I attached the operation log below.
--- operation log ---
postgres=> CREATE TABLE data1(c1 INT PRIMARY KEY, c2 VARCHAR(10));
CREATE TABLE
postgres=> CREATE TABLE data2(c1 INT PRIMARY KEY, c2 VARCHAR(10));
CREATE TABLE
postgres=> CREATE PUBLICATION pub1 FOR TABLE data1,data2 WHERE (c1 < 1000);
CREATE PUBLICATION
postgres=> \d data1
Table "public.data1"
Column | Type | Collation | Nullable | Default
--------+-----------------------+-----------+----------+---------
c1 | integer | | not null |
c2 | character varying(10) | | |
Indexes:
"data1_pkey" PRIMARY KEY, btree (c1)
Publications:
"pub1"
postgres=> \d data2
Table "public.data2"
Column | Type | Collation | Nullable | Default
--------+-----------------------+-----------+----------+---------
c1 | integer | | not null |
c2 | character varying(10) | | |
Indexes:
"data2_pkey" PRIMARY KEY, btree (c1)
Publications:
"pub1" WHERE (c1 < 1000)
postgres=> SELECT prrelid, prqual FROM pg_publication_rel;
prrelid | prqual
---------+-----------------------------------------------------------------------------
16408 |
16413 | {OPEXPR :opno 97 :opfuncid 66 :opresulttype 16 :opretset false :opcol
lid 0 :inputcollid 0 :args ({VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1
:varcollid 0 :varlevelsup 0 :varnosyn 1 :varattnosyn 1 :location 53} {CONST :con
sttype 23 :consttypmod -1 :constcollid 0 :constlen 4 :constbyval true :constisnu
ll false :location 58 :constvalue 4 [ -24 3 0 0 0 0 0 0 ]}) :location 56}
(2 rows)
Regards,
Noriyoshi Shinoda
-----Original Message-----
From: Amit Kapila <[email protected]>
Sent: Wednesday, February 23, 2022 11:06 AM
To: Euler Taveira <[email protected]>
Cc: [email protected]; Peter Smith <[email protected]>; Alvaro Herrera
<[email protected]>; Greg Nancarrow <[email protected]>; vignesh C
<[email protected]>; Ajin Cherian <[email protected]>;
[email protected]; Dilip Kumar <[email protected]>; Rahila Syed
<[email protected]>; Peter Eisentraut <[email protected]>;
Önder Kalacı <[email protected]>; japin <[email protected]>; Michael
Paquier <[email protected]>; David Steele <[email protected]>; Craig Ringer
<[email protected]>; Amit Langote <[email protected]>; PostgreSQL
Hackers <[email protected]>
Subject: Re: row filtering for logical replication
On Tue, Feb 22, 2022 at 4:47 AM Euler Taveira <[email protected]> wrote:
>
> On Thu, Feb 17, 2022, at 3:36 AM, Amit Kapila wrote:
>
> As there is a new version, I would like to wait for a few more days
> before committing. I am planning to commit this early next week (by
> Tuesday) unless others or I see any more things that can be improved.
>
> Amit, I don't have additional comments or suggestions. Let's move on.
> Next topic. :-)
>
Pushed!
--
With Regards,
Amit Kapila.
