RE: Support logical replication of DDLs

From: "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Japin Li <japinli(at)hotmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, rajesh singarapu <rajesh(dot)rs0541(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Zheng Li <zhengli10(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>
Subject: RE: Support logical replication of DDLs
Date: 2022-07-28 03:48:11
Message-ID: OS0PR01MB57168B82B65B491596F5832894969@OS0PR01MB5716.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Wednesday, July 20, 2022 8:28 PM houzj(dot)fnst(at)fujitsu(dot)com wrote:
> On Tuesday, July 12, 2022 5:04 PM houzj(dot)fnst(at)fujitsu(dot)com
> <houzj(dot)fnst(at)fujitsu(dot)com> wrote:
> > On Friday, July 8, 2022 10:26 AM Peter Smith <smithpb2250(at)gmail(dot)com>
> > wrote:
> >
> >
> > > Here are some review comments for the patch v11-0001:
> >
> > Attach the V12 patch set which include the following changes:
> >
> > * Address comments from peter[1]
> > * Refactor the deparser and provide an option to control whether
> > output the "not present" syntax part.
> > And for DDL replication, we don't WAL log the "not present" syntax
> > string for now.
> > * Address most comments from Vignesh[2] except the one about pg_dump
> > vs the event trigger for ddl replication which need some more research.
>
> Attach the new version patch set which added support for CREATE/ALTER
> FUNCTION, CREATE/ALTER PROCEDURE, CREATE/ALTER TRIGGER, RENAME
> TABLE/INDEX/SEQUENCE.
>
> Thanks to Vignesh for helping off list.

Attach the new version patch set which added support for
CREATE/ALTER OPERATOR [CLASS/FAMILY].
The DROP case need some more handling and I will update it later.

Best regards,
Hou zj

Attachment Content-Type Size
v14-0001-Functions-to-deparse-DDL-commands.patch application/octet-stream 184.3 KB
v14-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch application/octet-stream 15.1 KB
v14-0002-Support-DDL-replication.patch application/octet-stream 123.8 KB
v14-0004-Test-cases-for-DDL-replication.patch application/octet-stream 22.5 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wiwwo Staff 2022-07-28 09:23:11 Re: Feature request: psql --idle
Previous Message Alicja Kucharczyk 2022-07-27 18:19:55 Re:

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2022-07-28 04:26:33 Re: Improve description of XLOG_RUNNING_XACTS
Previous Message Amul Sul 2022-07-28 03:45:05 Re: [Patch] ALTER SYSTEM READ ONLY