Re: Support logical replication of DDLs

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Zheng Li <zhengli10(at)gmail(dot)com>
Cc: Dilip Kumar <dilipbalaut(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, rajesh(dot)rs0541(at)gmail(dot)com
Subject: Re: Support logical replication of DDLs
Date: 2022-03-16 22:06:18
Message-ID: 202203162206.7spggyktx63e@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hello

I think this is a pretty interesting and useful feature.

Did you see some old code I wrote towards this goal?
https://www.postgresql.org/message-id/20150215044814.GL3391@alvh.no-ip.org
The intention was that DDL would produce some JSON blob that accurately
describes the DDL that was run; the caller can acquire that and use it
to produce working DDL that doesn't depend on runtime conditions. There
was lots of discussion on doing things this way. It was ultimately
abandoned, but I think it's valuable.

--
Álvaro Herrera Valdivia, Chile — https://www.EnterpriseDB.com/
"Porque francamente, si para saber manejarse a uno mismo hubiera que
rendir examen... ¿Quién es el machito que tendría carnet?" (Mafalda)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Japin Li 2022-03-17 00:08:19 Re: Support logical replication of DDLs
Previous Message Zheng Li 2022-03-16 21:17:18 Re: Support logical replication of DDLs

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2022-03-16 22:50:23 Re: Proposal: Support custom authentication methods using hooks
Previous Message Imseih (AWS), Sami 2022-03-16 21:47:49 Re: Add index scan progress to pg_stat_progress_vacuum