Re: Support logical replication of DDLs

From: Zheng Li <zhengli10(at)gmail(dot)com>
To: Ajin Cherian <itsajin(at)gmail(dot)com>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(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>, 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-12-12 22:49:26
Message-ID: CAAD30UJG0ViTVdWNKu2rJXssmB5beCb+wEpph9ca6C3GC=Qvjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Mon, Dec 12, 2022 at 12:40 PM Zheng Li <zhengli10(at)gmail(dot)com> wrote:
>
> Hi,
>
> Patched v46-0001 no longer compiles after the recent commit
> 840ff5f451cd9a391d237fc60894fea7ad82a189, I resolved the conflicts in
> v47 patch.
>
> However, the following test case in the test_ddl_ddl-deparse_regress
> module is broken again, I'll look into it later:
>
> -- Test ALTER TABLE on inherited table
> CREATE TABLE gtest30 (
> a int,
> b int GENERATED ALWAYS AS (a * 2) STORED
> );
> CREATE TABLE gtest30_1 () INHERITS (gtest30);
> ALTER TABLE gtest30 ALTER COLUMN b DROP EXPRESSION;

Fixed the above issue in the v48 patch set.

Regards,
Zheng

Attachment Content-Type Size
v48-0004-Test-cases-for-DDL-replication.patch application/octet-stream 24.6 KB
v48-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch application/octet-stream 15.7 KB
v48-0005-Skip-ALTER-TABLE-subcommands-generated-for-TableLike.patch application/octet-stream 2.2 KB
v48-0002-Support-DDL-replication.patch application/octet-stream 132.5 KB
v48-0001-Functions-to-deparse-DDL-commands.patch application/octet-stream 317.5 KB
v48-0007-Introduce-the-test_ddl_deparse_regress-test-module.-.patch application/octet-stream 46.8 KB
v48-0006-Support-DDL-replication-of-alter-type-having-USING-e.patch application/octet-stream 9.0 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message li jie 2022-12-13 02:37:15 Re: Support logical replication of DDLs
Previous Message Reid Thompson 2022-12-12 18:22:39 Re: names of the WAL files

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Smith 2022-12-12 23:05:57 Re: Perform streaming logical transactions by background workers and parallel apply
Previous Message Peter Smith 2022-12-12 22:21:25 Re: Perform streaming logical transactions by background workers and parallel apply