Horton

Re: Support logical replication of DDLs

shveta malik <shveta.malik@gmail.com>

View thread
From: shveta malik <shveta.malik@gmail.com>
To: vignesh C <vignesh21@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>, "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>, Ajin Cherian <itsajin@gmail.com>, "Wei Wang (Fujitsu)" <wangw.fnst@fujitsu.com>, Runqi Tian <runqidev@gmail.com>, Peter Smith <smithpb2250@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, li jie <ggysxcq@gmail.com>, Dilip Kumar <dilipbalaut@gmail.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Masahiko Sawada <sawada.mshk@gmail.com>, Japin Li <japinli@hotmail.com>, rajesh singarapu <rajesh.rs0541@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Zheng Li <zhengli10@gmail.com>, shveta malik <shveta.malik@gmail.com>
Date: 2023-05-22T05:56:48Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add a run_as_owner option to subscriptions.

  2. Refactor pgoutput_change().

  3. Print the correct aliases for DML target tables in ruleutils.

  4. Fix object identity string for transforms

  5. Add grantable MAINTAIN privilege and pg_maintain role.

  6. Get rid of recursion-marker values in enum AlterTableType

  7. Release cache tuple when no longer needed

  8. Empty search_path in logical replication apply worker and walsender.

  9. Refactor format_type APIs to be more modular

  10. Use wrappers of PG_DETOAST_DATUM_PACKED() more.

Attachments

On Wed, May 17, 2023 at 4:45 PM vignesh C <vignesh21@gmail.com> wrote:
>
> On Wed, 17 May 2023 at 15:41, shveta malik <shveta.malik@gmail.com> wrote:
> >
> > On Fri, May 12, 2023 at 12:03 PM shveta malik <shveta.malik@gmail.com> wrote:
> > >
> > > On Tue, May 9, 2023 at 4:23 PM shveta malik <shveta.malik@gmail.com> wrote:
> > > >
> > > > On Mon, May 8, 2023 at 4:31 PM shveta malik <shveta.malik@gmail.com> wrote:
> > > > >
> > > > > On Mon, May 8, 2023 at 3:58 PM shveta malik <shveta.malik@gmail.com> wrote:
> > > > > >
> > > > > > On Tue, May 2, 2023 at 8:30 AM shveta malik <shveta.malik@gmail.com> wrote:
> > > > > > >
> > > > > > > On Fri, Apr 28, 2023 at 5:11 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> > > > > > > >
> > > > > > > > Now, I think we can try to eliminate this entire ObjTree machinery and
> > > > > > > > directly from the JSON blob during deparsing. We have previously also
> > > > > > > > discussed this in an email chain at [1]. I think now the functionality
> > > > > > > > of JSONB has also been improved and we should investigate whether it
> > > > > > > > is feasible to directly use JSONB APIs to form the required blob.
> > > > > > >
> > > > > > > +1.
> > > > > > > I will investigate this and will share my findings.
> > > > > > >
> > > > > >
> > > > > >
> > > > > > Please find the PoC patch for create-table after object-tree removal.
> > > > >
> > > >
> > >
> > > Please find the new set of patches attached for object-tree removal.
> >
> > Please find the new set of patches for object-tree Removal.  The new
> > changes are in patch 0008 only. The new changes incorporate the
> > object-tree removal for 'alter table' command.
>

Please find the new set of patches for object-tree Removal.  The new
changes are in patch 0008 only. The new changes address object tree
removal for below commands.

create sequence
alter sequence
alter object owner to
alter object set schema
alter object rename

In this patch 0008, ddldeparse.c is now object-tree free for all the
table related commands. Index related commands are yet to be done.

thanks
Shveta