Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wI370-007k6k-1o for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Apr 2026 11:29:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wI36y-003DZJ-2e for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Apr 2026 11:29:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wI36y-003DZA-1R for pgsql-hackers@lists.postgresql.org; Wed, 29 Apr 2026 11:29:48 +0000 Received: from mail-lf1-x131.google.com ([2a00:1450:4864:20::131]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wI36w-00000003Kzx-15x4 for pgsql-hackers@lists.postgresql.org; Wed, 29 Apr 2026 11:29:47 +0000 Received: by mail-lf1-x131.google.com with SMTP id 2adb3069b0e04-5a40d02b58bso10753976e87.3 for ; Wed, 29 Apr 2026 04:29:46 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777462183; cv=none; d=google.com; s=arc-20240605; b=GdNOTyIto4t+qzkw0lpm5aQaDWXPrhSdbTYNsn2pRxSPDMAw+ypjkIYkW33o6+YFqu IE7D+sqamrH+G+2JowqC0bSrUeRXvJ1rrlRXmbTuzNDm0z1W9k+PK9lVSTrAqRXkt7ci NlJz2AYrWNxSkuyFHhO2lZPHGK7s3DrU3evqO8EFSqYrE2v/m9rje+JMGNN0dcffkVT4 6fSYlzLNXPrjN5n7y8l3dg4VRi6rC+0FIjLb8ibqDEBDYkJIx8HUtMAxY+joCJTLancq FabZfKr/HAw1wiMxUY3IXHtQiNSds/nptNtbGWvL6xdyBsXq3wapfaYhHVU6MbAToVgw 2bpA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=7QYIOnBo8btSpLKdp5+1Jb07lVH2Yx3IBwGd0vTt0kI=; fh=y9EEfF3PQsi7Jw0r/Q2kYgmrjSZk7qzZmKPOoTwhDA8=; b=dkoTKG9rgiXJcogUh/t4qPFv2R0WQh111KtoMTUpah21Y5cFMdXatqE7zy/sjeORWz jtUf8ngkOSdWpmzQjYqvRTgQ4J66uv87M4DVnaxHon+isukSH0FxJjfp5veKMOt2G7U4 QE5NGGSsbTwW3beRoJSKD+oyjBz2eyyPFCprQrPqnYwJEYENd/sXFBAGaYzJJMSJn4n+ j5POPSuTfMYPOvVSmIiiIzXKKZD4N+9l1q4j5mc9ZIsJf28P6EDVJ3/x/r7715GHJlcz 2JPskgsB17m/wqZuRmKZsFCGHxLzuwlitfwDzyE71IdcwjAfOga+4+OIOvX+sAvVUBdh Yikg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777462183; x=1778066983; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=7QYIOnBo8btSpLKdp5+1Jb07lVH2Yx3IBwGd0vTt0kI=; b=QuU8y3wea/SQYpHxshGYZYbIQ7BtGcPqIPKUgLN+X0cYTVhly4xh7UTw5yho9oqntU pa5fzcwiHrq9gdlph46AbZ7ZNteY+bcdB0uktY4vSmSLnFxZq/Szyq0i0H9zpEM8Ey+G 06W4LliQuDZsVmFmnq5UFkdDCadQM0yf3UVHeXmsxgdJ7r9JWp6erhs5N+wtAF31lb1N p32ZcA5hnUsl4fKm18Vy71KxtdvY4PIuLgf/XloTOPMFeDZ/BCedI5YDc7YFdCoPqrUe nzR1+GXVYesYyuutQRgVIVhiLWtA7krD4z4qU/UYJOdaoI7R+9srOQ5lWRiNoPPpWx7U V65w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777462183; x=1778066983; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=7QYIOnBo8btSpLKdp5+1Jb07lVH2Yx3IBwGd0vTt0kI=; b=cntOd3ZB0grjG9hC+LdLeIVMj5jcnDLFqEs3d9GSxeqxxz2vOlx11z29KSeNgg9Ugy s+jQQeMXekZHaXtdNriOrMe4DDN4rHSRa8w9ch4Iyhu0P2pSzEomLTeAdaqv5cVp+SVM GEz//oDzmmBLjPdn8rp/mEnGYwmb9OpmyqRFV5GpQX+WHaH994Lf/XMLyP/DBk7KtaR0 qprKqNq+NzxxSDj9GH9mIxPlsYwvy4ro1y0WfZ9Rwvr6KVqhLrVsQ2bxQvCPFTzlyP0M oyXlkCNJtj4+chSSe9L213FcL9Afj0B5qOFuUjE9Jkm7c1mQ86kVHI4E11S4ZxROyoFy fGmQ== X-Forwarded-Encrypted: i=1; AFNElJ8IuSLi7OrKMKXxJ5eSmCpK4QZHhuk0/SNoAWS8iXqMUGPrtlf60edFHDhqVJwgxEDJqrdAnZIoS45twvfN@lists.postgresql.org X-Gm-Message-State: AOJu0Yz+z7UoGnwGyOU+QmxJMU+AiufYjxgLzUZbsuadTMsbJTUGZGhj Na7MkfZZCuoCl0uvUykH6/MbWyrJYjdo6SWUyxP7wCi77rY+b5ePMszpt5PQvxMAeSXvYwltwf/ ibd1THJszNZBhHdx8JQC1+MkpV7prthI= X-Gm-Gg: AeBDievOVE368Re6CHxcXrEB6E2dL2yINcjjJrqVmnWQ+6ua6Q5xV6PdfCFbNzXLqUH ZK/qkdR5yo+IpHf/wYHfVo4Cr41f2VjtI+GsEbNLDbJlW/rQEotzDRxNN7i6uzPuUEy450TLapF A+yT0UFjxZlKqt3wDrurTm/xMuhlqSacSbWJAet8y3YhfQ3ilkMmuv9czK+XOXbmcojKFOgzv16 qad8YIOpT4ngIrSDnaAedqlKRR83I9hrURAkXBpizaj2zoMC7ILhTmVW0PJzn6f/jlDCfzwqqUO Pke+GnT0dSodzRbjA5IsxwW6P1A= X-Received: by 2002:a05:6512:138e:b0:5a2:b51a:6a55 with SMTP id 2adb3069b0e04-5a7466142f9mr2507611e87.29.1777462183309; Wed, 29 Apr 2026 04:29:43 -0700 (PDT) MIME-Version: 1.0 References: <080f9394-c127-4cef-865e-10f2f997125c@postgrespro.ru> <38690b0e-f91b-46fa-b72a-57775612e463@postgrespro.ru> In-Reply-To: From: Dilip Kumar Date: Wed, 29 Apr 2026 16:59:26 +0530 X-Gm-Features: AVHnY4L-bkOhF0USSu_t82kZ7qi_-n6kP5ozT0D1j14ZfGin_QitI7DBPXveAHU Message-ID: Subject: Re: Support logical replication of DDLs, take2 To: Hannu Krosing Cc: Amit Kapila , Masahiko Sawada , Vitaly Davydov , Ashutosh Bapat , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Apr 29, 2026 at 1:37=E2=80=AFPM Hannu Krosing w= rote: > > On Wed, Apr 29, 2026 at 5:39=E2=80=AFAM Dilip Kumar wrote: > > Another question is > > what we would do with those deparsed representations: will we convert > > them to SQL on the subscriber and execute, or do something else? > > Current pg_dump approach is logically equivalent to "doing it on the > subscriber", pg_dump is designed to dump schemas from all older > database versions in format that is compatible with the version the > pg_dump is written for. IIUC, you're suggesting a pg_dump-style mechanism for SQL generation from the catalog. My concern is that pg_dump is snapshot-based, while decoding is incremental. So how to we generate SQL from the catalog for incremental changes(like an ALTER TABLE...SET DATA TYPE)? --=20 Regards, Dilip Kumar Google