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 1mupyr-0006EP-Nr for pgsql-committers@arkaria.postgresql.org; Wed, 08 Dec 2021 05:59: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 1mupyp-0002R4-Dj for pgsql-committers@arkaria.postgresql.org; Wed, 08 Dec 2021 05:59:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mupyp-0002Qv-20 for pgsql-committers@lists.postgresql.org; Wed, 08 Dec 2021 05:59:03 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mupyk-0001Fd-0k for pgsql-committers@lists.postgresql.org; Wed, 08 Dec 2021 05:59:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=xbolQ+XwxiOJBnzgFTXrLJpQITsf6DQMgrZfuLXbbg8=; b=q3k0SF9kL5D+0OcUwbRLx9yJvh o/XLt8N8B4Y88kG9b1jpXtjPz30r08sdR+oak44WkWE6zyzXj6Z9k+wncXBILpIAcR9mHCBvjqQ18 tKwc4jEGYmIfO9F2Rt/DPW/dzWCHlMRwfCHGLy1OT7NrQrpFA62brlXxb7dK0WK4Ub4binMkxULuz QSbrj0j/CtUEPX979fe849cVooje5rNAnA6yDOnu5yweCLtGj9bysjmKoGoOBQwb6GgzqIoTZ6G+D BWWIudYDenRjJQyJgWijLkZ3Pixy4HMJ885pIlA8KSn8W7AGaVidimyjUOLae0Tz2I0KbFzEzsB63 WnS4XuIg==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mupyj-0001En-Cb for pgsql-committers@lists.postgresql.org; Wed, 08 Dec 2021 05:58:57 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mupyi-0002xw-KA for pgsql-committers@lists.postgresql.org; Wed, 08 Dec 2021 05:58:56 +0000 Content-Type: multipart/mixed; boundary="===============0581389460012348457==" MIME-Version: 1.0 From: Amit Kapila To: pgsql-committers@lists.postgresql.org Subject: pgsql: De-duplicate the result of pg_publication_tables view. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 08 Dec 2021 05:58:56 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0581389460012348457== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RGUtZHVwbGljYXRlIHRoZSByZXN1bHQgb2YgcGdfcHVibGljYXRpb25fdGFibGVzIHZpZXcuCgpX ZSBzaG93IGR1cGxpY2F0ZSB2YWx1ZXMgZm9yIGNoaWxkIHRhYmxlcyBpbiBwdWJsaWNhdGlvbnMg dGhhdCBoYXZlIGJvdGgKY2hpbGQgYW5kIHBhcmVudCB0YWJsZXMgYW5kIGFyZSBwdWJsaXNoZWQg d2l0aCBwdWJsaXNoX3ZpYV9wYXJ0aXRpb25fcm9vdAphcyBmYWxzZSB3aGljaCBpcyBub3Qgd2hh dCB0aGUgdXNlciB3b3VsZCBleHBlY3QuCgpXZSBkZWNpZGVkIG5vdCB0byBiYWNrcGF0Y2ggdGhp cyBhcyB0aGVyZSBpcyBubyB1c2VyIGNvbXBsYWludCBhYm91dCB0aGlzCmFuZCBpdCBkb2Vzbid0 IHNlZW0gdG8gYmUgYSBjcml0aWNhbCBpc3N1ZS4KCkF1dGhvcjogSG91IFpoaWppZQpSZXZpZXdl ZC1ieTogQmhhcmF0aCBSdXBpcmVkZHksIEFtaXQgTGFuZ290ZSwgQW1pdCBLYXBpbGEKRGlzY3Vz c2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9PUzBQUjAxTUI1NzE2RTk3RjAwNzMyQjUyREMyQkJD MjU5NDk4OUBPUzBQUjAxTUI1NzE2LmpwbnByZDAxLnByb2Qub3V0bG9vay5jb20KCkJyYW5jaAot LS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcv cGcvY29tbWl0ZGlmZi9hNjFiZmYyYmY0NzljZmViZGExOGExNjU1MzIzZWVjMWIxOTM3MGRlCgpN b2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jYXRhbG9nL3BnX3B1Ymxp Y2F0aW9uLmMgICAgICB8IDQgKysrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3B1YmxpY2F0 aW9uLm91dCB8IDggKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvcHVibGljYXRpb24uc3Fs ICAgICAgfCA0ICsrKysKMyBmaWxlcyBjaGFuZ2VkLCAxNiBpbnNlcnRpb25zKCspCgo= --===============0581389460012348457==--