| From: | "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> |
|---|---|
| To: | Peter Smith <smithpb2250(at)gmail(dot)com> |
| Cc: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Euler Taveira <euler(at)eulerto(dot)com>, Greg Nancarrow <gregn4422(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Ajin Cherian <itsajin(at)gmail(dot)com>, "tanghy(dot)fnst(at)fujitsu(dot)com" <tanghy(dot)fnst(at)fujitsu(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Rahila Syed <rahilasyed90(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Önder Kalacı <onderkalaci(at)gmail(dot)com>, japin <japinli(at)hotmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, David Steele <david(at)pgmasters(dot)net>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | RE: row filtering for logical replication |
| Date: | 2021-12-27 13:15:40 |
| Message-ID: | OS0PR01MB5716A7ADC776818C5C6F334494429@OS0PR01MB5716.jpnprd01.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thur, Dec 23, 2021 4:28 PM Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
> Here is the v54* patch set:
Attach the v55 patch set which add the following testcases in 0003 patch.
1. Added a test to cover the case where TOASTed values are not included in the
new tuple. Suggested by Euler[1].
Note: this test is temporarily commented because it would fail without
applying another bug fix patch in another thread[2] which log the detoasted
value in old value. I have verified locally that the test pass after
applying the bug fix patch[2].
2. Add a test to cover the case that transform the UPDATE into INSERT. Provided
by Tang.
[1] https://www.postgresql.org/message-id/flat/6b6cf26d-bf74-4b39-bb07-c067e381d66d%40www.fastmail.com
[2} https://postgr.es/m/OS0PR01MB611342D0A92D4F4BF26C0F47FB229@OS0PR01MB6113.jpnprd01.prod.outlook.com
Best regards,
Hou zj
| Attachment | Content-Type | Size |
|---|---|---|
| v55-0002-Row-filter-updates-based-on-old-new-tuples.patch | application/octet-stream | 34.5 KB |
| v55-0001-Row-filter-for-logical-replication.patch | application/octet-stream | 132.2 KB |
| v55-0003-Row-filter-tab-auto-complete-and-pgdump.patch | application/octet-stream | 5.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | houzj.fnst@fujitsu.com | 2021-12-27 13:19:04 | RE: row filtering for logical replication |
| Previous Message | Ashutosh Bapat | 2021-12-27 13:15:08 | Re: Add Boolean node |