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>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: Ajin Cherian <itsajin(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Zheng Li <zhengli10(at)gmail(dot)com>, li jie <ggysxcq(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, 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: 2023-02-19 14:55:57
Message-ID: OS0PR01MB57169A7CC0514D86BA9362D894A79@OS0PR01MB5716.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Wed, Feb 15, 2023 at 13:57 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> On Fri, Feb 10, 2023 at 8:23 PM Masahiko Sawada
> <sawada(dot)mshk(at)gmail(dot)com>
> wrote:
> >
> > On Thu, Feb 9, 2023 at 6:55 PM Ajin Cherian <itsajin(at)gmail(dot)com> wrote:
> > >
> > (v67)
> >
> > I have some questions about adding the infrastructure for DDL deparsing.
> >
> > Apart from the changes made by 0001 patch to add infrastructure for
> > DDL deparsing, 0002 patch seems to add some variables that are not
> > used in 0002 patch:
> >
> > @@ -2055,6 +2055,7 @@ typedef struct AlterTableStmt
> > List *cmds; /* list of subcommands */
> > ObjectType objtype; /* type of object */
> > bool missing_ok; /* skip error if table
> > missing */
> > + bool table_like; /* internally generated for
> > TableLikeClause */
> > } AlterTableStmt;
> >
> > @@ -39,6 +40,7 @@ typedef struct CollectedATSubcmd {
> > ObjectAddress address; /* affected column,
> > constraint, index, ... */
> > Node *parsetree;
> > + char *usingexpr;
> > } CollectedATSubcmd;
> >
> > typedef struct CollectedCommand
> > @@ -62,6 +64,7 @@ typedef struct CollectedCommand
> > {
> > Oid objectId;
> > Oid classId;
> > + bool rewrite;
> > List *subcmds;
> > } alterTable;
> >
> > These three variables are used in 0006 patch.
> >
>
> Hmm, then it should be better to move these to 0006 patch.

Makes sense. Because the variables "table_like" and "usingexpr" are used in 0002 patch,
so I only moved "rewrite" to 0006 patch.

Best Regards,
Hou zj

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kirk Wolak 2023-02-19 19:43:16 A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5
Previous Message houzj.fnst@fujitsu.com 2023-02-19 14:54:40 RE: Support logical replication of DDLs

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2023-02-19 15:04:16 Re: Ignoring BRIN for HOT updates (was: -udpates seems broken)
Previous Message houzj.fnst@fujitsu.com 2023-02-19 14:54:40 RE: Support logical replication of DDLs