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-20 12:28:26
Message-ID: OS0PR01MB5716FCCEF8009E4464042476948E9@OS0PR01MB5716.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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.

Best regards,
Hou zj

Attachment Content-Type Size
v13-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch application/octet-stream 15.0 KB
v13-0002-Support-DDL-replication.patch application/octet-stream 123.5 KB
v13-0001-Functions-to-deparse-DDL-commands.patch application/octet-stream 166.6 KB
v13-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 Achilleas Mantzios 2022-07-20 12:28:48 Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity
Previous Message Achilleas Mantzios 2022-07-20 12:27:05 Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2022-07-20 12:51:55 Re: PATCH: Add Table Access Method option to pgbench
Previous Message Justin Pryzby 2022-07-20 12:27:07 Re: Allowing REINDEX to have an optional name