Re: Support logical replication of DDLs

From: Zheng Li <zhengli10(at)gmail(dot)com>
To: vignesh C <vignesh21(at)gmail(dot)com>
Cc: Ajin Cherian <itsajin(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, "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>, 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>, "runqidev(at)gmail(dot)com" <runqidev(at)gmail(dot)com>
Subject: Re: Support logical replication of DDLs
Date: 2022-10-18 01:08:55
Message-ID: CAAD30UKKkfPLRohPGa6XXJD9v1ZhRK3==3xNnqT0hDNtn5A+mg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi,

Attaching the v29 of the patch set which adds support for VIEW and
MATERIALIZED VIEW commands:
CREATE/ALTER/DROP VIEW
CREATE/ALTER/DROP MATERIALIZED VIEW

Note that, for VIEWSTMT, We created the function
pg_get_viewdef_internal() to get the
SELECT query of the pending VIEWSTMT. In the case that the CREATE VIEW command
is still in progress, we need to search the system cache RULERELNAME to get the
rewrite rule of the view as opposed to querying pg_rewrite as in
pg_get_viewdef_worker(),
the latter will return an empty result.

Thanks to Runiqi Tian for providing the changes on CREATE MATERIALIZED VIEW.

Regards,
Zheng

Attachment Content-Type Size
v29-0004-Test-cases-for-DDL-replication.patch application/octet-stream 24.6 KB
v29-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch application/octet-stream 15.0 KB
v29-0002-Support-DDL-replication.patch application/octet-stream 132.3 KB
v29-0001-Functions-to-deparse-DDL-commands.patch application/octet-stream 300.6 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dean Rasheed 2022-10-18 10:18:25 Re: Exponentiation confusion
Previous Message qiumingcheng 2022-10-18 00:17:44 回复：回复：回复：回复：回复：A question about leakproof

Browse pgsql-hackers by date

  From Date Subject
Next Message Andy Fan 2022-10-18 01:14:49 Re: Unnecessary lateral dependencies implied by PHVs
Previous Message Craig Ringer 2022-10-18 01:06:14 Re: POC: Better infrastructure for automated testing of concurrency issues