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 1ob17n-0006Vo-U2 for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2022 14:54:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ob17m-0007SB-Qk for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2022 14:54:54 +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 1ob17m-0007S1-7X for pgsql-hackers@lists.postgresql.org; Wed, 21 Sep 2022 14:54:54 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ob17k-0005jN-7F for pgsql-hackers@postgresql.org; Wed, 21 Sep 2022 14:54:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=Z6BR1m9oIrNAIRxYIafTUW7VsevCt9+9Cevv5GVFCNA=; b=GcJcDY0jsg0zjPXUdJ+uHOe8oo ekX3EZzoI3p5YMtRAqQJMSmqaOPryUz35LAotRXiMZcGfeCvlah98OSsElxOGziJsI3rQ6/FNko7z 1DxwXrT9WM7Z92ko5V1vWHjUf+6zFWKpY0d1ZEVg8e4kTlBZkKilxjXBSu0SlOR+s0dru/bBQ7dDC OewCDcOODgbbda59ABYFSYUsLPSTCTwhZjHzoVsMpGXRf8RPg7wWnwn7TmLT21gbqXu94YMzNGb0d 5ZS34FWCfg5zcyC3QAeZllDGv+c6S4TjJ7PUlB2ptSqeW+xoRzqHC2f7E4xOpNY45z5ekBzGdr0H4 rnsWgpMQ==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ob17d-0008Dh-U8; Wed, 21 Sep 2022 14:54:47 +0000 Message-ID: <6d878c98-6094-11b2-9161-5523b95eb38d@postgresql.org> Date: Wed, 21 Sep 2022 10:54:39 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: why can't a table be part of the same publication as its schema Content-Language: en-US To: Alvaro Herrera , Robert Haas Cc: "houzj.fnst@fujitsu.com" , Amit Kapila , vignesh C , Tom Lane , pgsql-hackers , Peter Eisentraut References: <20220921142422.3geaqus4ebuwtew2@alvherre.pgsql> From: "Jonathan S. Katz" In-Reply-To: <20220921142422.3geaqus4ebuwtew2@alvherre.pgsql> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------cDzSdspPMO2Z07D9greyhNiR" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------cDzSdspPMO2Z07D9greyhNiR Content-Type: multipart/mixed; boundary="------------ukwn1xzPGm8AzU8bhmSEUs81"; protected-headers="v1" From: "Jonathan S. Katz" To: Alvaro Herrera , Robert Haas Cc: "houzj.fnst@fujitsu.com" , Amit Kapila , vignesh C , Tom Lane , pgsql-hackers , Peter Eisentraut Message-ID: <6d878c98-6094-11b2-9161-5523b95eb38d@postgresql.org> Subject: Re: why can't a table be part of the same publication as its schema References: <20220921142422.3geaqus4ebuwtew2@alvherre.pgsql> In-Reply-To: <20220921142422.3geaqus4ebuwtew2@alvherre.pgsql> --------------ukwn1xzPGm8AzU8bhmSEUs81 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOS8yMS8yMiAxMDoyNCBBTSwgQWx2YXJvIEhlcnJlcmEgd3JvdGU6DQo+IE9uIDIwMjIt U2VwLTIwLCBSb2JlcnQgSGFhcyB3cm90ZToNCj4gDQo+Pj4gSSBkb24ndCB0aGluayB3ZSBz aG91bGQgY2hhbmdlIHRoaXMgYmVoYXZpb3IgdGhhdCdzIGFscmVhZHkgaW4gbG9naWNhbA0K Pj4+IHJlcGxpY2F0aW9uLiBXaGlsZSBJIHVuZGVyc3RhbmQgdGhlIHJlYXNvbnMgd2h5ICJH UkFOVCAuLi4gQUxMIFRBQkxFUyBJTg0KPj4+IFNDSEVNQSIgaGFzIGEgZGlmZmVyZW50IGJl aGF2aW9yIChpLmUuIGl0J3Mgbm90IGFwcGxpZWQgdG8gZnV0dXJlDQo+Pj4gb2JqZWN0cykg YW5kIGRvIG5vdCBhZHZvY2F0ZSB0byBjaGFuZ2UgaXQsIEkgaGF2ZSBwZXJzb25hbGx5IGJl ZW4NCj4+PiBhZmZlY3RlZCB3aGVyZSBJIHRob3VnaHQgYSBwZXJtaXNzaW9uIHdvdWxkIGJl IGFwcGxpZWQgdG8gYWxsIGZ1dHVyZQ0KPj4+IG9iamVjdHMsIG9ubHkgdG8gZGlzY292ZXIg b3RoZXJ3aXNlLiBJIGJlbGlldmUgaXQncyBtb3JlIGludHVpdGl2ZSB0bw0KPj4+IHRoaW5r IHRoYXQgIkFMTCIgYXBwbGllcyB0byAiZXZlcnl0aGluZywgYWx3YXlzLiINCj4+DQo+PiBO YWgsIHRoZXJlJ3Mgcm9vbSBmb3IgbXVsdGlwbGUgYmVoYXZpb3JzIGhlcmUuIEl0J3MgcmVh c29uYWJsZSB0byB3YW50DQo+PiB0byBhZGQgYWxsIHRoZSB0YWJsZXMgY3VycmVudGx5IGlu IHRoZSBzY2hlbWEgdG8gYSBwdWJsaWNhdGlvbiAob3INCj4+IGdyYW50IHBlcm1pc3Npb25z IG9uIHRoZW0pIGFuZCBpdCdzIHJlYXNvbmFibGUgdG8gd2FudCB0byBpbmNsdWRlIGFsbA0K Pj4gY3VycmVudCBhbmQgZnV0dXJlIHRhYmxlcyBpbiB0aGUgc2NoZW1hIGluIGEgcHVibGlj YXRpb24gKG9yIGdyYW50DQo+PiBwZXJtaXNzaW9ucyBvbiB0aGVtKSB0b28uIFRoZSByZWFz b24gSSBkb24ndCBsaWtlIHRoZSBBTEwgVEFCTEVTIElODQo+PiBTQ0hFTUEgc3ludGF4IGlz IHRoYXQgaXQgc291bmRzIGxpa2UgdGhlIGZvcm1lciwgYnV0IGFjdHVhbGx5IGlzIHRoZQ0K Pj4gbGF0dGVyLiBCYXNlZCBvbiB5b3VyIGxpbmsgdG8gdGhlIGVtYWlsIGZyb20gVG9tLCBJ IHVuZGVyc3RhbmQgbm93IHRoZQ0KPj4gcmVhc29uIHdoeSBpdCdzIGxpa2UgdGhhdCwgYnV0 IGl0J3Mgc3RpbGwgY291bnRlcmludHVpdGl2ZSB0byBtZS4NCj4gDQo+IEkgYWxyZWFkeSBw cm9wb3NlZCBlbHNld2hlcmUgdGhhdCB3ZSByZW1vdmUgdGhlIEFMTCBrZXl3b3JkIGZyb20g dGhlcmUsDQo+IHdoaWNoIEkgdGhpbmsgc2VydmVzIHRvIHJlZHVjZSBjb25mdXNpb24gKGlu IHBhcnRpY3VsYXIgaXQncyBubyBsb25nZXINCj4gcGFyYWxsZWwgdG8gdGhlIEdSQU5UIG9u ZSkuICBBcyBpbiB0aGUgYXR0YWNoZWQuDQoNCltwZXJzb25hbCwgbm90IFJNVCBoYXRdDQoN CkknZCBiZSBPSyB3aXRoIHRoaXMuIEl0IHdvdWxkIHN0aWxsIGFsbG93IGZvciAiRk9SIFNF UVVFTkNFUyBJTiBTQ0hFTUEiIGV0Yy4NCg0KSm9uYXRoYW4NCg0K --------------ukwn1xzPGm8AzU8bhmSEUs81-- --------------cDzSdspPMO2Z07D9greyhNiR Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmMrJa8FAwAAAAAACgkQ8QSccp8cZSct AA//RastoPgdD3Ths2J5MIGpA3Bb1rSWN4JcsY00tqMq1wzSEtOtMjPTfcSi5zRos4D+cJU3jgD6 Kc8D8BhD7P56czeA5xcMEo2sSYJs1MUviQe76g+VxgsSgnblVY2SmaPPse4M0xY/P338xkbgG+9f dTLPrBJPjDSHW8Smue/YikdqoalV4aGpgfkT1NTV9jNXbJsuDxO+aeUOY0x4xplyeG5GcvB0IJZu EPI/xHI+XedMi2jT4ReaKUjuaHR8fbeevYp8u8Zkhj0+zi3X1enwyxWfnkHfzMcDOHBjPAfdGl8U mgKoeugFvW5AJ8BlI8PBACXsCzKQhSInUuQxw1nX1weedwLoAm4mak5ivgKfQ3qBT81aM70g9h8U WAs1pU7SPDWIdy8nz75N3RBEpk7pv8nA9Dj/xwX2ikqF3Fd811vm+vF0oFQgq6aIMY9/i1haYXy+ /wLgJl+Pl6k40l4yT7SOZoPmH9iwuGorqZOOK1WVC7zHM/SXxlNonY1qtuZYcl4K6YPz4iLdK3Zw g0FwPADvflY6TMxho2nbEXlUzIhJP2xILeYwqh/0kQRq/tnuE0Oxou15Y6Kyv7hzAlQFHbZyl9ez Sqxx72flu60FL5TWlMSfiSabe27OzTF9wgw0lKFru6himZgKeIPeSxWIQ2Ul37Of/WxaJUpjeUr7 kSE= =TNbI -----END PGP SIGNATURE----- --------------cDzSdspPMO2Z07D9greyhNiR--