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 1oaj39-0001D3-Ms for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Sep 2022 19:36:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oaj37-0008Ib-TF for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Sep 2022 19:36:53 +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 1oaj37-0008IR-Bb for pgsql-hackers@lists.postgresql.org; Tue, 20 Sep 2022 19:36:53 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oaj2z-000207-5h for pgsql-hackers@postgresql.org; Tue, 20 Sep 2022 19:36:51 +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:Subject:From: References:Cc:To:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=9shHaASRlkDRiHyE0r6YIJtd1nAjNGPkbhYFQcUyqRI=; b=aWu9/uG5eosPveRw7b+AqNLkGk KrU2Drj0+SNJ3zY4xJHM5aJAdVXKaFXavbPBpgG9G6rtNKkULtNpehxP7F1m82fsFGLmJzX27+f4o t4uREz9+nwzSdovbGsLkdu5YtRWbCUOP8XHIBr2LyhUxeVV6XWyrZGcSCtKyYY4MplX4H6fIkEh/7 +0mCI1wExS22YnqBZIYwhIKksFm5MtyMWVx7uES8l6uTlYUszpNe/wN3GQEXMUeCp07XuvMjZrzDw YBxFFaHC/adJsufFc3NltgXdcrpoaVa4BgwH0Hlj5sc68d2qrTZ1W0eVlfDnjg3vtvoIikjCnnwep 2uEbfgHQ==; 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 1oaj2n-0008LQ-FQ; Tue, 20 Sep 2022 19:36:35 +0000 Message-ID: Date: Tue, 20 Sep 2022 15:36:28 -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 Content-Language: en-US To: Mark Dilger Cc: Alvaro Herrera , "houzj.fnst@fujitsu.com" , Amit Kapila , vignesh C , Robert Haas , Tom Lane , pgsql-hackers , Peter Eisentraut References: <20220919151627.ah6dhz7me4uiooz3@alvherre.pgsql> <12f66d81-8675-dbf4-a770-4094d478551a@postgresql.org> From: "Jonathan S. Katz" Subject: Re: why can't a table be part of the same publication as its schema In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------04dOyRQu4PTInQzM8hKaJKae" 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) --------------04dOyRQu4PTInQzM8hKaJKae Content-Type: multipart/mixed; boundary="------------lgqolCyt62GpR3hfGxloaNQ6"; protected-headers="v1" From: "Jonathan S. Katz" To: Mark Dilger Cc: Alvaro Herrera , "houzj.fnst@fujitsu.com" , Amit Kapila , vignesh C , Robert Haas , Tom Lane , pgsql-hackers , Peter Eisentraut Message-ID: Subject: Re: why can't a table be part of the same publication as its schema References: <20220919151627.ah6dhz7me4uiooz3@alvherre.pgsql> <12f66d81-8675-dbf4-a770-4094d478551a@postgresql.org> In-Reply-To: --------------lgqolCyt62GpR3hfGxloaNQ6 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOS8yMC8yMiAxMDo1NSBBTSwgTWFyayBEaWxnZXIgd3JvdGU6DQo+IA0KPiANCj4+IE9u IFNlcCAxOSwgMjAyMiwgYXQgODowMyBQTSwgSm9uYXRoYW4gUy4gS2F0eiA8amthdHpAcG9z dGdyZXNxbC5vcmc+IHdyb3RlOg0KPj4NCj4+ICJXaGVuIGEgcGFydGl0aW9uZWQgdGFibGUg aXMgYWRkZWQgdG8gYSBwdWJsaWNhdGlvbiwgYWxsIG9mIGl0cyBleGlzdGluZyBhbmQgZnV0 dXJlIHBhcnRpdGlvbnMgYXJlIGltcGxpY2l0bHkgY29uc2lkZXJlZCB0byBiZSBwYXJ0IG9m IHRoZSBwdWJsaWNhdGlvbi4iWzEwXQ0KPj4NCj4+IEFkZGl0aW9uYWxseSwgdGhpcyBpcyB0 aGUgYmVoYXZpb3IgdGhhdCBpcyBhbHJlYWR5IHByZXNlbnQgaW4gIkZPUiBBTEwgVEFCTEVT IjoNCj4+DQo+PiAiTWFya3MgdGhlIHB1YmxpY2F0aW9uIGFzIG9uZSB0aGF0IHJlcGxpY2F0 ZXMgY2hhbmdlcyBmb3IgYWxsIHRhYmxlcyBpbiB0aGUgZGF0YWJhc2UsIGluY2x1ZGluZyB0 YWJsZXMgY3JlYXRlZCBpbiB0aGUgZnV0dXJlLiJbMTBdDQo+Pg0KPj4gSSBkb24ndCB0aGlu ayB3ZSBzaG91bGQgY2hhbmdlIHRoaXMgYmVoYXZpb3IgdGhhdCdzIGFscmVhZHkgaW4gbG9n aWNhbCByZXBsaWNhdGlvbi4NCj4gDQo+IFRoZSBleGlzdGluZyBiZWhhdmlvciBpbiBsb2dp Y2FsIHJlcGxpY2F0aW9uIGRvZXNuJ3QgaGF2ZSBhbnkgIklOIFNDSEVNQSIgcXVhbGlmaWVy cy4NCg0KVGhpcyBiZWhhdmlvciBleGlzdHMgIkZPUiBBTEwgVEFCTEVTIiB3aXRob3V0IHRo ZSAiSU4gU0NIRU1BIiBxdWFsaWZpZXIuIA0KVGhpcyB3YXMgZGlzY3Vzc2VkIG11bHRpcGxl IHRpbWVzIG9uIHRoZSBvcmlnaW5hbCB0aHJlYWRbMV0uDQoNCj4gDQo+PiBXaGlsZSBJIHVu ZGVyc3RhbmQgdGhlIHJlYXNvbnMgd2h5ICJHUkFOVCAuLi4gQUxMIFRBQkxFUyBJTiBTQ0hF TUEiIGhhcyBhIGRpZmZlcmVudCBiZWhhdmlvciAoaS5lLiBpdCdzIG5vdCBhcHBsaWVkIHRv IGZ1dHVyZSBvYmplY3RzKSBhbmQgZG8gbm90IGFkdm9jYXRlIHRvIGNoYW5nZSBpdCwgSSBo YXZlIHBlcnNvbmFsbHkgYmVlbiBhZmZlY3RlZCB3aGVyZSBJIHRob3VnaHQgYSBwZXJtaXNz aW9uIHdvdWxkIGJlIGFwcGxpZWQgdG8gYWxsIGZ1dHVyZSBvYmplY3RzLCBvbmx5IHRvIGRp c2NvdmVyIG90aGVyd2lzZS4gSSBiZWxpZXZlIGl0J3MgbW9yZSBpbnR1aXRpdmUgdG8gdGhp bmsgdGhhdCAiQUxMIiBhcHBsaWVzIHRvICJldmVyeXRoaW5nLCBhbHdheXMuIg0KPiANCj4g VGhlIGNvbnZlcnNhdGlvbiBpcyBmb2N1c2luZyBvbiB3aGF0ICJBTEwgVEFCTEVTIiBtZWFu cywgYnV0IHRoZSBhbWJpZ3VvdXMgcGFydCBpcyB3aGF0ICJJTiBTQ0hFTUEiIG1lYW5zLiAg SW4gR1JBTlQgaXQgbWVhbnMgImN1cnJlbnRseSBpbiBzY2hlbWEsIGNvbXB1dGVkIG5vdy4i ICBXZSBhcmUgYWJvdXQgdG8gY3JlYXRlIGNvbmZ1c2lvbiBieSBhZGRpbmcgdGhlICJJTiBT Q0hFTUEiIHBocmFzZSB0byBwdWJsaWNhdGlvbiBjb21tYW5kcyBtZWFuaW5nICJsYXRlciBp biBzY2hlbWEsIGNvbXB1dGVkIHRoZW4uIiAgQSB1c2VyIHdobyBkaWxpZ2VudGx5IGNvbnN1 bHRzIHRoZSBkb2N1bWVudGF0aW9uIGZvciBvbmUgY29tbWFuZCB0byBkaXNjb3ZlciB3aGF0 ICJJTiBTQ0hFTUEiIG1lYW5zIG1heSBmYWlybHksIGJ1dCB3cm9uZ2x5LCBhc3N1bWUgaXQg bWVhbnMgdGhlIHNhbWUgdGhpbmcgaW4gYW5vdGhlciBjb21tYW5kLg0KDQpJIHRyaWVkIHRv IGRpbGlnZW50bHkgcmVhZCB0aGUgc2VjdGlvbnMgd2hlcmUgd2UgdGFsayBhYm91dCBncmFu dGluZyArIA0KcHJpdmlsZWdlc1syXVszXSB0byBzZWUgd2hhdCBpdCBzYXlzIGFib3V0ICJB TEwgKiBJTiBTQ0hFTUEiLiBVbmxlc3MgSSANCm1pc3NlZCBpdCwgYW5kIEkgcmVhZCB0aHJv dWdoIGl0IHR3aWNlLCBpdCBkb2VzIG5vdCBleHBsaWNpdGx5IHN0YXRlIA0Kd2hldGhlciBv ciBub3QgIkdSQU5UIiBhcHBsaWVzIHRvIGFsbCBvYmplY3RzIGF0IG9ubHkgdGhhdCBnaXZl biBtb21lbnQsIA0Kb3IgdG8gZnV0dXJlIG9iamVjdHMgb2YgdGhhdCB0eXBlIHdoaWNoIGFy ZSBjcmVhdGVkIGluIHRoYXQgc2NoZW1hLiANCk1heWJlIHRoZSBiZWhhdmlvciBpcyBpbXBs aWVkIG9yIGlzIHBhcnQgb2YgdGhlIHN0YW5kYXJkLCBidXQgaXQncyBub3QgDQpjdXJyZW50 bHkgZG9jdW1lbnRlZC4gV2UgZG8gbGluayB0byAiQUxURVIgREVGQVVMVCBQUklWSUxFR0VT IiBhdCB0aGUgDQpib3R0b20gb2YgdGhlIEdSQU5UWzJdIGRvY3MsIGJ1dCB3ZSBkb24ndCBn aXZlIGFueSBpbmRpY2F0aW9uIGFzIHRvIHdoeS4NCg0KKFRoaXMgaXMgYWxzbyB0byBzYXkg d2Ugc2hvdWxkIGRvY3VtZW50IGluIEdSQU5UIHRoYXQgQUxMICogSU4gU0NIRU1BIA0KZG9l cyBub3QgYXBwbHkgdG8gZnV0dXJlIG9iamVjdHM7IGlmIHlvdSBuZWVkIHRoYXQgYmVoYXZp b3IgdXNlIEFMVEVSIA0KREVGQVVMVCBQUklWSUxFR0VTLiBTZXBhcmF0ZSB0aHJlYWQgOikN Cg0KSSB1bmRlcnN0YW5kIHRoZXJlIGlzIGEgcmlzayBvZiBjb25mdXNpb24gb2YgdGhlIHNp bWlsYXIgZ3JhbW1hciBhY3Jvc3MgDQpjb21tYW5kcywgYnV0IHRoZSBjdXJyZW50IGNvbW1h bmQgaW4gbG9naWNhbCByZXBsaWNhdGlvbiBoYXMgdGhpcyBpcyANCmJ1aWxkaW5nIG9uIHRo ZSBleGlzdGluZyBiZWhhdmlvci4NCg0KVGhhbmtzLA0KDQpKb25hdGhhbg0KDQpbMV0gDQpo dHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL2ZsYXQvQ0FMRGFObTBPQU54 dUo2Ulhxd1pzTTFNU1k0czE5bnVIMzczNGo0YTcyZXREd3ZCRVRRJTQwbWFpbC5nbWFpbC5j b20NClsyXSBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1cnJlbnQvc3FsLWdy YW50Lmh0bWwNClszXSBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1cnJlbnQv ZGRsLXByaXYuaHRtbA0K --------------lgqolCyt62GpR3hfGxloaNQ6-- --------------04dOyRQu4PTInQzM8hKaJKae 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/x8QSccp8cZScFAmMqFjwFAwAAAAAACgkQ8QSccp8cZScu kRAAqp5m8AKj+JtdhLg7bs+fIREF9eKV3cvzx7J2VEtYd5WtHgiWtFHr1By/leDRBOhY0k3/EbXI hNP2Iw/QPGgYcfw11Qox8tCmhUcgJ+Q3Kt1TtnlCzIYa0E443nQLoUj8wRdvH/3o56B7Tz+TuGf2 JZIEsct15kC4hSOmgEgIRrhMbve8vSsTcgb53eAYZH/DurhTrCovzbmRet4BrKGfcCctxtmBbXzn x49v7OPNAH4SA5brcWSx9g6X48hSLt2jCTB96AQzw/Tdx8RKDrxFgSLSPy4SzbRjdU+mRxnwJAhs Ta10YpXGRfJuFVosqWoU2mhdgRmI9a3gUnGcMyZoN4WwTUQzhCexKaGlDLK0RZNQGHmZ4rC9GWOK hI47CW0RJrtzD8FxK+jeTKlRuRzNYhUHUVmNOzuCW4AalTE8pki6oTfnM5Xn7Ei8KYvI7MVSA/e+ Eg7I/FkXM74LHs59F86H8GFV11m6dhMBZGSO8kibOsxdhuHFSJuSKTcfzTlq5ZjRHotBPkjA9O0R vQKE3epJd+/aNJrpCdcgAnbarXopq1LXNNqYOdPrJaFjDUvEgwzK3PZyxGwr+0JpXOEsPPg1i1zQ TFowDKFYGe4nSDknzPFdK5siG7nrWwPV4EVKvYatDc1uVCW67u288kRxTvtyO4Ms6Oz2gqRC4JVr 3Ok= =ec2f -----END PGP SIGNATURE----- --------------04dOyRQu4PTInQzM8hKaJKae--