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 17:40:19
Message-ID: CAAD30UL_ZqvikjE0SpJ=1e1RNYeQSYq5ehHnZ0uez6x7d-7nfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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;

Regards,
Zheng

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reid Thompson 2022-12-12 18:22:39 Re: names of the WAL files
Previous Message Matthias Apitz 2022-12-12 17:16:39 names of the WAL files

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2022-12-12 17:41:58 Re: Minimal logical decoding on standbys
Previous Message Nathan Bossart 2022-12-12 17:33:51 Re: Add sub-transaction overflow status in pg_stat_activity