Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pjewM-0003bV-9I for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Apr 2023 11:35:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pjewK-0005Yg-2p for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Apr 2023 11:35:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pjewJ-0005YW-NI for pgsql-hackers@lists.postgresql.org; Tue, 04 Apr 2023 11:35:03 +0000 Received: from mail-wr1-x431.google.com ([2a00:1450:4864:20::431]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pjewG-000p7h-GQ for pgsql-hackers@lists.postgresql.org; Tue, 04 Apr 2023 11:35:02 +0000 Received: by mail-wr1-x431.google.com with SMTP id v1so32441649wrv.1 for ; Tue, 04 Apr 2023 04:35:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1680608099; 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=h5YntUXwVLCxXMPkQDDWeqnvvDlAgdChnDDf80D+Moc=; b=X14Vj+vtnqUPeTZXpTI89WMa7ke4G3gXVBxDbEP1AAEagQReXKnMpZL7gwv45T1XEl wGsiwTZvUzfFtHeT+Q1FSgwy+gral6eLbXEAbDHYQvdMh/VK12hoTuyAy/2Y5sOsOUtx Ujmho91JrlrzH1eUa6V+LbqNSMwDfPPuvYdDSXNX8ilM+13IXEedrRpJ848L4jskBPyC WjP6PVtVSox8nr5wCehpVt17boW3XRU/WvRlmZ9AmidAEI64Adw92GgS+Dn8qhoz2TPv b6sPrpRhC67K+g3v2c3Xsquy5a+/5SeU0ApF8Nga/hq9z+nIsrjCha1aErOx2HhZ/GFz WXvg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1680608099; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=h5YntUXwVLCxXMPkQDDWeqnvvDlAgdChnDDf80D+Moc=; b=78QFoO0brT3EqfGGcjLx17zl5pJssqUKy4vejq9h+AS/OAEvLUE50v5HukdSDMMuXp +gbJnQQALJj5MMYaCJgkp0S1zc1E6xdDQUzZKNo2xkXoyFuQyMUCK0dgK6JNFf631C9e Ty2bjuNvjEa3KAjlwTsi/keepY4bPSCQQwILgAfc4yySf3GaKKYiUyQQxUaCcJGBmre9 ihLC9Xw2xU+/YdTtWqeAyOSETHnXC5JWx1OYhydsYgkPSF+1353V3VJM10fJ2UHz0HZ9 4n4X70OOPG2mB19qTsc01MYFRIPubmAIKbHB3mHzXNYuCcDavSc9t9eJ2g7WXeX4I0Mw eXFw== X-Gm-Message-State: AAQBX9f3i+Ibdk25J0QQMD4SQUVOqrs/50mihzO7rU2I3hZlORRQET/7 bYkf3gozCCVKT0pxIaihGKHx4UvmJs7/Pzfbjk8= X-Google-Smtp-Source: AKy350YWor0kYCwqXwOBbwMy6xZnNAkj1VIzRT/qKxpy+UfVb7CwJ3zLXuf/qgCQjBMqUrTUx9HkzOvmGcFS0TL2u+g= X-Received: by 2002:a05:6000:5c1:b0:2d7:9771:fc4b with SMTP id bh1-20020a05600005c100b002d79771fc4bmr6302565wrb.5.1680608098726; Tue, 04 Apr 2023 04:34:58 -0700 (PDT) MIME-Version: 1.0 References: <3032112.1679865718@sss.pgh.pa.us> In-Reply-To: From: shveta malik Date: Tue, 4 Apr 2023 17:04:47 +0530 Message-ID: Subject: Re: Support logical replication of DDLs To: "houzj.fnst@fujitsu.com" Cc: vignesh C , Amit Kapila , Ajin Cherian , "wangw.fnst@fujitsu.com" , Runqi Tian , Peter Smith , Tom Lane , li jie , Dilip Kumar , Alvaro Herrera , Masahiko Sawada , Japin Li , rajesh singarapu , PostgreSQL Hackers , Zheng Li , shveta malik 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 Tue, Apr 4, 2023 at 8:43=E2=80=AFAM houzj.fnst@fujitsu.com wrote: > Attach the new version patch set which did the following changes: > Hello, I tried below: pubnew=3D# ALTER PUBLICATION mypub2 SET (ddl =3D 'table'); ALTER PUBLICATION pubnew=3D# \dRp+ Publication mypub2 Owner | All tables | All DDLs | Table DDLs | --------+------------+----------+------------+--------- shveta | t | f | f (1 row) I still see 'Table DDLs' as false and ddl replication did not work for this case. thanks Shveta