Re: Support logical replication of DDLs

From: Ajin Cherian <itsajin(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Zheng Li <zhengli10(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, rajesh(dot)rs0541(at)gmail(dot)com, Hou, Zhijie/侯 志杰 <houzj(dot)fnst(at)fujitsu(dot)com>
Subject: Re: Support logical replication of DDLs
Date: 2022-05-10 15:17:27
Message-ID: CAFPTHDYza7PZqKdkyoRUpJTDC26x_XZtJnFwtiyy9C_HuUS7OA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Tue, May 10, 2022 at 9:33 PM Ajin Cherian <itsajin(at)gmail(dot)com> wrote:
>
> On Fri, May 6, 2022 at 11:24 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> > As we have hacked CreatePublication function for this POC, the
> > regression tests are not passing but we can easily change it so that
> > we invoke new functionality with the syntax proposed in this thread or
> > with some other syntax and we shall do that in the next patch unless
> > this approach is not worth pursuing.
> >
> > This POC is prepared by Ajin Cherian, Hou-San, and me.
> >
> > Thoughts?
> >
> > [1] - https://www.postgresql.org/message-id/20150215044814.GL3391%40alvh.no-ip.org
>
> I have updated Amit's patch by including a public action "create" when
> creating publication which is turned off by default.
> Now the 'make check' tests pass. I also fixed a problem that failed to
> create tables when the table has a primary key.

Sorry, I sent the wrong patches. Here is the correct one.

regards,
Ajin Cherian
Fujitsu Australia

Attachment Content-Type Size
v2-0001-Functions-to-deparse-DDL-commands.patch application/octet-stream 62.6 KB
v2-0002-Support-DDL-replication.patch application/octet-stream 104.5 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zheng Li 2022-05-10 15:48:01 Re: Support logical replication of DDLs
Previous Message Amit Kapila 2022-05-10 12:39:37 Re: Support logical replication of DDLs

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2022-05-10 15:44:15 First draft of the PG 15 release notes
Previous Message Jonathan S. Katz 2022-05-10 14:43:02 Re: JSON constructors and window functions