On Thu, 17 Apr 2025 at 09:12, Amit Kapila <amit.kapil...@gmail.com> wrote: > > On Wed, Apr 16, 2025 at 8:22 AM Zhijie Hou (Fujitsu) > <houzj.f...@fujitsu.com> wrote: > > > > On Thu, Apr 10, 2025 at 7:25 PM Amit Kapila wrote: > > > > > > On Tue, Jan 9, 2024 at 12:02 PM vignesh C <vignes...@gmail.com> wrote: > > > > > > > > As I did not see much interest from others, I'm withdrawing this patch > > > > for now. But if there is any interest others in future, I would be > > > > more than happy to work on this feature. > > > > > > > > > > Just FYI, I noticed a use case for this patch in email [1]. Users would > > > like to > > > replicate all except a few columns having sensitive information. The > > > challenge > > > with current column list features is that adding new tables to columns > > > would > > > lead users to change the respective publications as well. > > > > > > [1] - > > > https://www.postgresql.org/message-id/tencent_DCDF626FCD4A556C51BE > > > 270FDC3047540208%40qq.com > > > > BTW, I noticed that debezium, an open source distributed platform for change > > data capture that replies on logical decoding, also support specifying the > > column exclusion list[1]. So, this indicates that there could be some use > > cases > > for this feature. > > > > Thanks for sharing the link. I see that they support both the include > and exclude lists for columns and tables. >
Hi Hackers, I see there is some interest in the functionality added by this patch. I have rebased the patches in [1]. I saw a new column 'pubgencols' was added in pg_publication in PG 18. So, I have modified v11-0001 to RESET this as well. I am also working on creating a patch to exclude columns in publication as per suggestion in [2]. [1]: https://www.postgresql.org/message-id/CALDaNm3dWZCYDih55qTNAYsjCvYXMFv%3D46UsDWmfCnXMt3kPCg%40mail.gmail.com [2]: https://www.postgresql.org/message-id/CAA4eK1KRdAPC%3D5%3D7tQ1GW0cRwD%3DzaDMi%2BT4u_k4GxPhPY6e8BQ%40mail.gmail.com Thanks and Regards, Shlok Kyal
v11-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch
Description: Binary data
v11-0002-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch
Description: Binary data
