Re: Support logical replication of DDLs

From: vignesh C <vignesh21(at)gmail(dot)com>
To: Zheng Li <zhengli10(at)gmail(dot)com>
Cc: Ajin Cherian <itsajin(at)gmail(dot)com>, "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, 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>
Subject: Re: Support logical replication of DDLs
Date: 2022-09-30 07:47:13
Message-ID: CALDaNm0VnaCg__huSDW=n=_rSGGES90cpOtqwZeWnA6muoz3oA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Mon, 26 Sept 2022 at 15:56, vignesh C <vignesh21(at)gmail(dot)com> wrote:
>
> Hi,
>
> The patch does not apply because of a recent commit. The updated patch
> is rebased on top of HEAD.
>

Adding support for ddl replication of the following:
Create Rule
Alter Rule
Drop Rule
Create Foreign Data Wrapper
Alter Foreign Data Wrapper
Drop Foreign Data Wrapper
Revoke
Refresh Materialized View

Thanks to Ajin Cherian for providing the changes for Create/Alter/Drop
Foreign Data Wrapper.
The attached v24 patch has the changes for the same.

Regards,
Vignesh

Attachment Content-Type Size
v24-0004-Test-cases-for-DDL-replication.patch text/x-patch 24.6 KB
v24-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch text/x-patch 15.0 KB
v24-0005-Add-DDL-deparser-support-for-TEXT-SEARCH-command.patch text/x-patch 18.4 KB
v24-0002-Support-DDL-replication.patch text/x-patch 129.4 KB
v24-0001-Functions-to-deparse-DDL-commands.patch text/x-patch 257.0 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wen Yi 2022-09-30 08:42:46 [BeginnerQuestion]Why I compile lex.yy.c failed?
Previous Message Lahnov, Igor 2022-09-30 06:17:39 RE: Streaming wal from primiry terminating

Browse pgsql-hackers by date

  From Date Subject
Next Message bt22nakamorit 2022-09-30 07:54:06 Re: Make ON_ERROR_STOP stop on shell script failure
Previous Message Drouvot, Bertrand 2022-09-30 07:35:47 log_heap_visible(): remove unused parameter and update comment