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 1oaNla-0004de-Fs for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Sep 2022 20:53:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oaNkb-0000u3-4v for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Sep 2022 20:52:21 +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 1oaNka-0000tt-NX for pgsql-hackers@lists.postgresql.org; Mon, 19 Sep 2022 20:52:20 +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 1oaNkY-0007fa-5X for pgsql-hackers@postgresql.org; Mon, 19 Sep 2022 20:52:19 +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=9sqABZpbae7Vccw2MO+j38k+0yQb3gi3+pFTCBs2jQY=; b=hdh+kxJaTIra62rM9R8EPT/RUO v/8zM2eF/kxLyFSGPLnqTLJL7NybsITN1xUNYUTx/Cmoxs4ai4RK5VtW9QQqjosBhIPzCoKHMElik 9Em+EvE/x3im+4foHAGWoJ0rFezNm/nhZpcNy88+DowjHLrLv4HvAibg9iVOZ4pPcccxWRcrEC6j/ PzBxX2FewqWHLFjfUnr1qbcyzNRCYZHa8efaVeP2DodyGOZ4DPiXejfd64y/RHgZHFebZ9JLVx4sA cM4tOVdPomMrHQunhjam+/Gq0QVpezUC1x9Vx5sHtQ+wTq8FwY2A0kLf68ZMrnF/oppMFR9extEnc W6aeMkqg==; 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 1oaNkR-0005S6-4H; Mon, 19 Sep 2022 20:52:13 +0000 Message-ID: <12f66d81-8675-dbf4-a770-4094d478551a@postgresql.org> Date: Mon, 19 Sep 2022 16:52:06 -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 , "houzj.fnst@fujitsu.com" Cc: Amit Kapila , vignesh C , Robert Haas , Tom Lane , pgsql-hackers , Peter Eisentraut References: <20220919151627.ah6dhz7me4uiooz3@alvherre.pgsql> From: "Jonathan S. Katz" In-Reply-To: <20220919151627.ah6dhz7me4uiooz3@alvherre.pgsql> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------UuxJBxUNciI0H2qyIqxS2axx" 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) --------------UuxJBxUNciI0H2qyIqxS2axx Content-Type: multipart/mixed; boundary="------------3ajMhLvbzgaEUKpWpXNQXx25"; protected-headers="v1" From: "Jonathan S. Katz" To: Alvaro Herrera , "houzj.fnst@fujitsu.com" Cc: Amit Kapila , vignesh C , Robert Haas , Tom Lane , pgsql-hackers , Peter Eisentraut Message-ID: <12f66d81-8675-dbf4-a770-4094d478551a@postgresql.org> Subject: Re: why can't a table be part of the same publication as its schema References: <20220919151627.ah6dhz7me4uiooz3@alvherre.pgsql> In-Reply-To: <20220919151627.ah6dhz7me4uiooz3@alvherre.pgsql> --------------3ajMhLvbzgaEUKpWpXNQXx25 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOS8xOS8yMiAxMToxNiBBTSwgQWx2YXJvIEhlcnJlcmEgd3JvdGU6DQo+IA0KPj4gZGlm ZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9sb2dpY2FsLXJlcGxpY2F0aW9uLnNnbWwgYi9kb2Mv c3JjL3NnbWwvbG9naWNhbC1yZXBsaWNhdGlvbi5zZ21sDQo+PiBpbmRleCAxYWUzMjg3Li4w YWI3NjhkIDEwMDY0NA0KPj4gLS0tIGEvZG9jL3NyYy9zZ21sL2xvZ2ljYWwtcmVwbGljYXRp b24uc2dtbA0KPj4gKysrIGIvZG9jL3NyYy9zZ21sL2xvZ2ljYWwtcmVwbGljYXRpb24uc2dt bA0KPj4gQEAgLTExMjAsNiArMTEyMCwxMSBAQCB0ZXN0X3N1Yj0jIFNFTEVDVCAqIEZST00g Y2hpbGQgT1JERVIgQlkgYTsNCj4+ICAgICA8L3BhcmE+DQo+PiAgIA0KPj4gICAgIDxwYXJh Pg0KPj4gKyAgIFNwZWNpZnlpbmcgYSBjb2x1bW4gbGlzdCB3aGVuIHRoZSBwdWJsaWNhdGlv biBhbHNvIHB1Ymxpc2hlcw0KPj4gKyAgIDxsaXRlcmFsPkZPUiBBTEwgVEFCTEVTIElOIFND SEVNQTwvbGl0ZXJhbD4gaXMgbm90IHN1cHBvcnRlZC4NCj4+ICsgIDwvcGFyYT4NCj4+ICsN Cj4+ICsgIDxwYXJhPg0KPj4gICAgICBGb3IgcGFydGl0aW9uZWQgdGFibGVzLCB0aGUgcHVi bGljYXRpb24gcGFyYW1ldGVyDQo+PiAgICAgIDxsaXRlcmFsPnB1Ymxpc2hfdmlhX3BhcnRp dGlvbl9yb290PC9saXRlcmFsPiBkZXRlcm1pbmVzIHdoaWNoIGNvbHVtbiBsaXN0DQo+PiAg ICAgIGlzIHVzZWQuIElmIDxsaXRlcmFsPnB1Ymxpc2hfdmlhX3BhcnRpdGlvbl9yb290PC9s aXRlcmFsPiBpcw0KPj4NCj4+IGRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvcmVmL2NyZWF0 ZV9wdWJsaWNhdGlvbi5zZ21sIGIvZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfcHVibGljYXRp b24uc2dtbA0KPj4gaW5kZXggMGE2OGM0Yi4uMGNlZDdkYSAxMDA2NDQNCj4+IC0tLSBhL2Rv Yy9zcmMvc2dtbC9yZWYvY3JlYXRlX3B1YmxpY2F0aW9uLnNnbWwNCj4+ICsrKyBiL2RvYy9z cmMvc2dtbC9yZWYvY3JlYXRlX3B1YmxpY2F0aW9uLnNnbWwNCj4+IEBAIC0xMDMsMTcgKzEw MywxNyBAQCBDUkVBVEUgUFVCTElDQVRJT04gPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0 ZXIiPm5hbWU8L3JlcGxhY2VhYmxlPg0KPj4gICAgICAgIDwvcGFyYT4NCj4+ICAgDQo+PiAg ICAgICAgPHBhcmE+DQo+PiArICAgICAgU3BlY2lmeWluZyBhIGNvbHVtbiBsaXN0IHdoZW4g dGhlIHB1YmxpY2F0aW9uIGFsc28gcHVibGlzaGVzDQo+PiArICAgICAgPGxpdGVyYWw+Rk9S IEFMTCBUQUJMRVMgSU4gU0NIRU1BPC9saXRlcmFsPiBpcyBub3Qgc3VwcG9ydGVkLg0KPj4g KyAgICAgPC9wYXJhPg0KPj4NCj4+IEBAIC03MzMsNiArNjk0LDI0IEBAIENoZWNrUHViUmVs YXRpb25Db2x1bW5MaXN0KExpc3QgKnRhYmxlcywgY29uc3QgY2hhciAqcXVlcnlTdHJpbmcs DQo+PiAgIAkJCWNvbnRpbnVlOw0KPj4gICANCj4+ICAgCQkvKg0KPj4gKwkJICogRGlzYWxs b3cgc3BlY2lmeWluZyBjb2x1bW4gbGlzdCBpZiBhbnkgc2NoZW1hIGlzIGluIHRoZQ0KPj4g KwkJICogcHVibGljYXRpb24uDQo+PiArCQkgKg0KPj4gKwkJICogWFhYIFdlIGNvdWxkIGlu c3RlYWQganVzdCBmb3JiaWQgdGhlIGNhc2Ugd2hlbiB0aGUgcHVibGljYXRpb24NCj4+ICsJ CSAqIHRyaWVzIHRvIHB1Ymxpc2ggdGhlIHRhYmxlIHdpdGggYSBjb2x1bW4gbGlzdCBhbmQg YSBzY2hlbWEgZm9yIHRoYXQNCj4+ICsJCSAqIHRhYmxlLiBIb3dldmVyLCBpZiB3ZSBkbyB0 aGF0IHRoZW4gd2UgbmVlZCBhIHJlc3RyaWN0aW9uIGR1cmluZw0KPj4gKwkJICogQUxURVIg VEFCTEUgLi4uIFNFVCBTQ0hFTUEgdG8gcHJldmVudCBzdWNoIGEgY2FzZSB3aGljaCBkb2Vz bid0DQo+PiArCQkgKiBzZWVtIHRvIGJlIGEgZ29vZCBpZGVhLg0KPj4gKwkJICovDQo+PiAr CQlpZiAocHVibGlzaF9zY2hlbWEpDQo+PiArCQkJZXJlcG9ydChFUlJPUiwNCj4+ICsJCQkJ CWVycmNvZGUoRVJSQ09ERV9JTlZBTElEX1BBUkFNRVRFUl9WQUxVRSksDQo+PiArCQkJCQll cnJtc2coImNhbm5vdCB1c2UgcHVibGljYXRpb24gY29sdW1uIGxpc3QgZm9yIHJlbGF0aW9u IFwiJXMuJXNcIiIsDQo+PiArCQkJCQkJICAgZ2V0X25hbWVzcGFjZV9uYW1lKFJlbGF0aW9u R2V0TmFtZXNwYWNlKHByaS0+cmVsYXRpb24pKSwNCj4+ICsJCQkJCQkgICBSZWxhdGlvbkdl dFJlbGF0aW9uTmFtZShwcmktPnJlbGF0aW9uKSksDQo+PiArCQkJCQllcnJkZXRhaWwoIkNv bHVtbiBsaXN0IGNhbm5vdCBiZSBzcGVjaWZpZWQgaWYgYW55IHNjaGVtYSBpcyBwYXJ0IG9m IHRoZSBwdWJsaWNhdGlvbiBvciBzcGVjaWZpZWQgaW4gdGhlIGxpc3QuIikpOw0KPj4gKw0K PiANCj4gVGhpcyBzZWVtcyBhIHByZXR0eSBhcmJpdHJhcnkgcmVzdHJpY3Rpb24uICBJdCBm ZWVscyBsaWtlIHlvdSdyZSBhZGRpbmcNCj4gdGhpcyByZXN0cmljdGlvbiBwcmVjaXNlbHkg c28gdGhhdCB5b3UgZG9uJ3QgaGF2ZSB0byB3cml0ZSB0aGUgY29kZSB0bw0KPiByZWplY3Qg dGhlIEFMVEVSIC4uIFNFVCBTQ0hFTUEgaWYgYW4gaW5jb21wYXRpYmxlIGNvbmZpZ3VyYXRp b24gaXMNCj4gZGV0ZWN0ZWQuICBCdXQgd2UgYWxyZWFkeSBoYXZlIHN1Y2ggY2hlY2tzIGlu IHNldmVyYWwgY2FzZXMsIHNvIEkgZG9uJ3QNCj4gc2VlIHdoeSB0aGlzIG9uZSBkb2VzIG5v dCBzZWVtIGEgZ29vZCBpZGVhLg0KPiANCj4gVGhlIHdob2xlIEZPUiBBTEwgVEFCTEVTIElO IFNDSEVNQSB0aGluZyBzZWVtcyBwcmV0dHkgd2VpcmQgaW4gc2V2ZXJhbA0KPiBhc3BlY3Rz LiAgT3RoZXJzIGhhdmUgYWxyZWFkeSBjb21tZW50ZWQgYWJvdXQgdGhlIHN5bnRheCwgd2hp Y2ggaXMNCj4gdW5saWtlIHdoYXQgR1JBTlQgdXNlczsgSSdtIGFsc28gc3VycHJpc2VkIHRo YXQgd2UndmUgZ290dGVuIGF3YXkgd2l0aA0KPiBpdCBiZWluZyBzdXBlcnVzZXItb25seS4g IFdoeSBhcmUgd2UgYnVpbGRpbmcgbW9yZSBzdXBlcnVzZXItb25seQ0KPiBmZWF0dXJlcyBp biB0aGlzIGRheSBhbmQgYWdlPyAgSSB0aGluayBub3QgZXZlbiBGT1IgQUxMIFRBQkxFUyBz aG91bGQNCj4gcmVxdWlyZSBzdXBlcnVzZXIuDQoNCkZZSSwgSSd2ZSBhZGRlZCB0aGlzIHRv IHRoZSBQRzE1IG9wZW4gaXRlbXMgYXMgdGhlcmUgYXJlIHNvbWUgb3BlbiANCnF1ZXN0aW9u cyB0byByZXNvbHZlIGluIHRoaXMgdGhyZWFkLg0KDQpKb25hdGhhbg0KDQo= --------------3ajMhLvbzgaEUKpWpXNQXx25-- --------------UuxJBxUNciI0H2qyIqxS2axx 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/x8QSccp8cZScFAmMo1nYFAwAAAAAACgkQ8QSccp8cZScL vQ/9G8bgE52L/Z2tzxLhyq/KUgUTZcFiR6KbD1VP8/7KgYcg74UpA1uiwYdmzKMzqbdskfYNPIhK AqNJLzDkil6n4/9NSe8Zs3xXPP0O1AXoB4H/fMgabo7/MKHyc2cRtxx2a92uP+I12Z1IvFTFdRMa duRirat2ESr15gXCoT/8J2CPMC6OjVvVsAHY5i5Wt2Elrtqz//43z/A5gSleh5LHZ1hXdSN3OnoN Uw7nkyC3hwjVC9WvehL/Mq0OROaG53mZ+S4pD/AGL7Xs8xllCi/gBU5zjtbNc+YlS4ovM9RUo/9W zo6PfLStU3PsAlF0Vjkyk7K1HxY4Q9fJR8n4A3Vo7IY6y3zazx2k3sSuaCjUlTphvGySsXeX03Zx BwyZ5qEV3FPbHFOwIxc7JwtnImmby6bbwQPv97Jyfe5MxMJiH8aeY1uhhYxjR8HBL6Nxb+xytXpr 1Hn1ejwD9ihhXTBXkeRpuP5tJD5gPVbsR9xXRjlwNRWzoI2rrL1mDM/bOYVHR+/ZZahWuSQueWiN Az7i2AOaOuufJn7nuispcL/O80KDWwhb+uYGryCAqfuh9RiTpp1VdM3qFqRi8Wtb3VWyJ48VXFpG J7CpuVuug0jBSbMr6G2blmvJyZPvEBkOjPqYV/BM3JvLkUBI7Wrs6Is5KSWUqpHJJLF+znp1TTlF QPE= =HU0G -----END PGP SIGNATURE----- --------------UuxJBxUNciI0H2qyIqxS2axx--