| From: | Brad Nicholson <brad(dot)nicholson(at)instacart(dot)com> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Where Clause not being applied to all tables in a publication |
| Date: | 2023-08-30 18:43:22 |
| Message-ID: | CAMMnM=9qDFDQH+QH7fBnR7KPKxkJpyfVfdENJru9EmwdWEmVOw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
When adding more than one table to a logical replication publication with a
where clause, the where clause is only applied to a single table in the
publication, not all of them.
Basic test case:
testdb=# create table foo (id bigserial primary key);
CREATE TABLE
testdb=# create table bar (id bigserial primary key);
CREATE TABLE
testdb=# CREATE PUBLICATION test_pub for table foo,bar WHERE (id = 1);
CREATE PUBLICATION
testdb=# select * from pg_publication_tables \gx
-[ RECORD 1 ]--------
pubname | test_pub
schemaname | public
tablename | foo
attnames | {id}
rowfilter |
-[ RECORD 2 ]--------
pubname | test_pub
schemaname | public
tablename | bar
attnames | {id}
rowfilter | (id = 1)
Thanks,
Brad
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2023-08-30 18:46:53 | Re: Where Clause not being applied to all tables in a publication |
| Previous Message | Muhammad Ali Ansari | 2023-08-30 17:27:06 | Re: BUG #18075: configuration variable idle_session_timeout not working as expected |