Date: Mon, 16 Feb 2026 10:16:56 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>,
	Vitaly Davydov <v.davydov@postgrespro.ru>,
	pgsql-hackers@lists.postgresql.org
Subject: Re: Support logical replication of DDLs
Message-ID: <aZM06GUh10sxe1Ma@momjian.us>
References: <CAJpy0uAhLjQZ0Dh0KWDFP8mrnG0rbx99_heavwn8Ke8ZuD-Umg@mail.gmail.com>
 <OS0PR01MB5716A47D23EFAF988475D4A99431A@OS0PR01MB5716.jpnprd01.prod.outlook.com>
 <CAD21AoCXCAQ5QyXu9-xs30ViUHtUxQMmf-818d8GX--5pTmZ7g@mail.gmail.com>
 <OS0PR01MB57163E6487EFF7378CB8E17C9438A@OS0PR01MB5716.jpnprd01.prod.outlook.com>
 <B38B7239-92B0-4212-A8BF-FE506C3B0F66@yandex-team.ru>
 <CAA4eK1JpAcvnfOqF2DQo79pf7Cqp5=3HU5UDwBonWXW4V9ot=w@mail.gmail.com>
 <080f9394-c127-4cef-865e-10f2f997125c@postgrespro.ru>
 <CAD21AoCzjzr5VqVkpVWkN7V6vrFhac=yXSNMz6rkSE+KOPPU0w@mail.gmail.com>
 <aY5QMkm8xHnU32M_@momjian.us>
 <CAA4eK1LuH1JCJ_AjyU07P-qwVJajv9-p91r66=J1FvoG8f7bsQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <CAA4eK1LuH1JCJ_AjyU07P-qwVJajv9-p91r66=J1FvoG8f7bsQ@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/aZM06GUh10sxe1Ma%40momjian.us>
Precedence: bulk

On Mon, Feb 16, 2026 at 03:24:16PM +0530, Amit Kapila wrote:
> On Fri, Feb 13, 2026 at 3:42 AM Bruce Momjian <bruce@momjian.us> wrote:
> > pg_upgrade had a similar challenge, and I found that pushing as much of
> > the changes _out_ of pg_upgrade and to other parts of the system, e.g,,
> > pg_dump, was a big help.  I am not sure if that is possible for
> > replicated DDL, but if it is, I would pursue it.
> >
> 
> The other reason to pursue a deparsing approach is to allow "Schema
> and Object Redirection" between source and target. For example, users
> may want to redirect operations from a source object (e.g.,
> HR.ACCOUNTS on the source) to a different target object (e.g.,
> HR_BACKUP.ACCT on the target). Many people in the past supported such
> flexibility in DDL replication which is one of the reasons we pursued
> a deparsing approach in the past though that project/approach is
> paused for the time being. I admit that there were many unresolved
> challenges apart from the maintenance part of that approach.

I understand the desire to get two features from one set of changes, but
taking one hard feature and trying to get a second one accomplished
usually, for me, ends in failure.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.