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 1oaTZ9-0005LM-IW for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Sep 2022 03:04: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 1oaTY8-0003eY-Q4 for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Sep 2022 03:03:52 +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 1oaTY8-0003eP-FL for pgsql-hackers@lists.postgresql.org; Tue, 20 Sep 2022 03:03:52 +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 1oaTY5-00043x-1K for pgsql-hackers@postgresql.org; Tue, 20 Sep 2022 03:03: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:References: Cc:To:From:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=YxB0x49jxrzGDL+XBpIasH93X1LCvFrFnSN9MDHpx6g=; b=CakezpXLH4+zqEhDixb3jD9y0a jOcVlgsoQbmigd3JsWUdPw03Ebb5nCZE5kEcMgJuZ6+xrMU06v1364kRJ0BlxQGDGg4mT8LCSkBKx 1vv9ZaRbaw9YxO/YZZ0xC8rEVHOFkYwO0AMAb8EWS96x900OMrpcoGK9mZIRAWUEtvlOYMjelqR6G RfVq/LhCSMrRVXD7C7rNdyvPtYQvdtHEr4MhAZ+k3tTjEW8y2yl4zN68KB2GujHOI2Jnh0wEY0frH bTQU/Z4p8lAdOEtj2It0se7DMQKbPsShmM1Sb/CRtKCYfHXKAecJr98o4ur3Eu7SctK2ehbOD0PyQ YlY+3j7Q==; 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 1oaTXy-00037O-Cf; Tue, 20 Sep 2022 03:03:44 +0000 Message-ID: Date: Mon, 19 Sep 2022 23:03:38 -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 From: "Jonathan S. Katz" 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> <12f66d81-8675-dbf4-a770-4094d478551a@postgresql.org> Subject: Re: why can't a table be part of the same publication as its schema In-Reply-To: <12f66d81-8675-dbf4-a770-4094d478551a@postgresql.org> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------sBsSZMyxCBKquyyFbG4Fx20z" 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) --------------sBsSZMyxCBKquyyFbG4Fx20z Content-Type: multipart/mixed; boundary="------------hmSyzTa0X8YubqPe3dAM5H68"; 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: 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: <12f66d81-8675-dbf4-a770-4094d478551a@postgresql.org> --------------hmSyzTa0X8YubqPe3dAM5H68 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOS8xOS8yMiA0OjUyIFBNLCBKb25hdGhhbiBTLiBLYXR6IHdyb3RlOg0KPiBPbiA5LzE5 LzIyIDExOjE2IEFNLCBBbHZhcm8gSGVycmVyYSB3cm90ZToNCg0KPj4gVGhpcyBzZWVtcyBh IHByZXR0eSBhcmJpdHJhcnkgcmVzdHJpY3Rpb24uwqAgSXQgZmVlbHMgbGlrZSB5b3UncmUg YWRkaW5nDQo+PiB0aGlzIHJlc3RyaWN0aW9uIHByZWNpc2VseSBzbyB0aGF0IHlvdSBkb24n dCBoYXZlIHRvIHdyaXRlIHRoZSBjb2RlIHRvDQo+PiByZWplY3QgdGhlIEFMVEVSIC4uIFNF VCBTQ0hFTUEgaWYgYW4gaW5jb21wYXRpYmxlIGNvbmZpZ3VyYXRpb24gaXMNCj4+IGRldGVj dGVkLsKgIEJ1dCB3ZSBhbHJlYWR5IGhhdmUgc3VjaCBjaGVja3MgaW4gc2V2ZXJhbCBjYXNl cywgc28gSSBkb24ndA0KPj4gc2VlIHdoeSB0aGlzIG9uZSBkb2VzIG5vdCBzZWVtIGEgZ29v ZCBpZGVhLg0KPj4NCj4+IFRoZSB3aG9sZSBGT1IgQUxMIFRBQkxFUyBJTiBTQ0hFTUEgdGhp bmcgc2VlbXMgcHJldHR5IHdlaXJkIGluIHNldmVyYWwNCj4+IGFzcGVjdHMuwqAgT3RoZXJz IGhhdmUgYWxyZWFkeSBjb21tZW50ZWQgYWJvdXQgdGhlIHN5bnRheCwgd2hpY2ggaXMNCj4+ IHVubGlrZSB3aGF0IEdSQU5UIHVzZXM7IEknbSBhbHNvIHN1cnByaXNlZCB0aGF0IHdlJ3Zl IGdvdHRlbiBhd2F5IHdpdGgNCj4+IGl0IGJlaW5nIHN1cGVydXNlci1vbmx5LsKgIFdoeSBh cmUgd2UgYnVpbGRpbmcgbW9yZSBzdXBlcnVzZXItb25seQ0KPj4gZmVhdHVyZXMgaW4gdGhp cyBkYXkgYW5kIGFnZT/CoCBJIHRoaW5rIG5vdCBldmVuIEZPUiBBTEwgVEFCTEVTIHNob3Vs ZA0KPj4gcmVxdWlyZSBzdXBlcnVzZXIuDQo+IA0KPiBGWUksIEkndmUgYWRkZWQgdGhpcyB0 byB0aGUgUEcxNSBvcGVuIGl0ZW1zIGFzIHRoZXJlIGFyZSBzb21lIG9wZW4gDQo+IHF1ZXN0 aW9ucyB0byByZXNvbHZlIGluIHRoaXMgdGhyZWFkLg0KDQooUmVwbHlpbmcgcGVyc29uYWxs eSwgbm90IFJNVCkuDQoNCkkgd2FudGVkIHRvIGVudW1lcmF0ZSB0aGUgY29uY2VybnMgcmFp c2VkIGluIHRoaXMgdGhyZWFkIGluIHRoZSBjb250ZXh0IA0Kb2YgdGhlIG9wZW4gaXRlbSB0 byB1bmRlcnN0YW5kIHdoYXQgbmVlZHMgdG8gYmUgYWRkcmVzc2VkLCBhbmQgYWxzbyBnaXZl IA0KYW4gb3Bpbmlvbi4gSSBkaWQgcmVhZCB1cCBvbiB0aGUgb3JpZ2luYWwgdGhyZWFkIHRv IGJldHRlciB1bmRlcnN0YW5kIA0KY29udGV4dCBhcm91bmQgZGVjaXNpb25zLg0KDQpJIGJl bGlldmUgdGhlIGNvbmNlcm5zIGFyZSB0aGVzZSAzIHRoaW5nczoNCg0KMS4gQWxsb3dpbmcg Y2FsbHMgdGhhdCBoYXZlICJBTEwgVEFCTEVTIElOIFNDSEVNQSIgdGhhdCBpbmNsdWRlIGNh bGxzIHRvIA0Kc3BlY2lmaWMgdGFibGVzIGluIHNjaGVtYQ0KMi4gVGhlIHN5bnRheCBvZiB0 aGUgIkFMTCBUQUJMRVMgSU4gU0NIRU1BIiBhbmQgY29tcGFyaW5nIGl0IHRvIHNpbWlsYXIg DQpiZWhhdmlvcnMgaW4gUG9zdGdyZVNRTA0KMy4gQWRkaW5nIG9uIGFuIGFkZGl0aW9uYWwg InN1cGVydXNlci1vbmx5IiBmZWF0dXJlDQoNCkZvciAjMSAoYWxsb3dpbmcgY2FsbHMgdGhh dCBoYXZlIHNjaGVtYS90YWJsZSBvdmVybGFwLi4uKSwgdGhlcmUgYXBwZWFycyANCnRvIGJl IGJvdGggYSBwYXRjaCB0aGF0IGFsbG93cyB0aGlzIChyZXZlcnNpbmdbOF0pLCBhbmQgYSBz dWdnZXN0aW9uIGZvciANCmRlYWxpbmcgd2l0aCBhIGNvcm5lci1jYXNlIHRoYXQgaXMgcmVh c29uYWJsZSwgaS5lLiBkaXNhbGxvd2luZyBhZGRpbmcgDQpzY2hlbWFzIHRvIGEgcHVibGlj YXRpb24gd2hlbiBzcGVjaWZ5aW5nIGNvbHVtbi1saXN0cy4gRG8gd2UgdGhpbmsgd2UgDQpj YW4gaGF2ZSBjb25zZW5zdXMgb24gdGhpcyBwcmlvciB0byB0aGUgUkMxIGZyZWV6ZT8NCg0K Rm9yICMyICgiQUxMIFRBQkxFUyBJTiBTQ0hFTUEiIHN5bnRheCksIHRoaXMgd2FzIGhlYXZp bHkgZGlzY3Vzc2VkIG9uIA0KdGhlIG9yaWdpbmFsIHRocmVhZFsxXVszXVs0XVs1XVs3XS4g SSB0aG91Z2h0IFRvbSdzIHByb3Bvc2FsIG9uIHRoZSANCnN5bnRheFszXSB3YXMgcmVhc29u YWJsZSBhcyBpdCAiZnV0dXJlIHByb29mcyIgZm9yIHdoZW4gd2UgYWxsb3cgb3RoZXIgDQpz Y2hlbWEtc2NvcGVkIG9iamVjdHMgdG8gYmUgcHVibGlzaGVkIGFuZCBnaXZlIGNvbnRyb2wg b3ZlciB3aGljaCBvbmVzIA0KY2FuIGJlIHB1Ymxpc2hlZC4NCg0KVGhlIGJpZ2dlciBpc3N1 ZSBzZWVtcyB0byBiZSBhcm91bmQgdGhlIGJlaGF2aW9yIGluIHJlZ2FyZHMgdG8gdGhlIA0K c3ludGF4LiBUaGUgY3VycmVudCBiZWhhdmlvciBpcyB0aGF0IHdoZW4gb25lIHNwZWNpZmll cyAiQUxMIFRBQkxFUyBJTiANClNDSEVNQSIsIGFueSBmdXR1cmUgdGFibGVzIGNyZWF0ZWQg aW4gdGhhdCBzY2hlbWEgYXJlIGFkZGVkIHRvIHRoZSANCnB1YmxpY2F0aW9uLiBXaGlsZSBm b2xrcyB0cmllZCB0byBmaW5kIHBhcmFsbGVscyB0byBHUkFOVFs2XSwgSSB0aGluayANCnRo aXMgYWN0dWFsbHkgcmVzZW1ibGVzIGhvdyB3ZSBoYW5kbGUgcGFydGl0aW9ucyB0aGF0IGFy ZSANCnB1Ymxpc2hlZFs5XVsxMF0sIGkuZS46DQoNCiJXaGVuIGEgcGFydGl0aW9uZWQgdGFi bGUgaXMgYWRkZWQgdG8gYSBwdWJsaWNhdGlvbiwgYWxsIG9mIGl0cyBleGlzdGluZyANCmFu ZCBmdXR1cmUgcGFydGl0aW9ucyBhcmUgaW1wbGljaXRseSBjb25zaWRlcmVkIHRvIGJlIHBh cnQgb2YgdGhlIA0KcHVibGljYXRpb24uIlsxMF0NCg0KQWRkaXRpb25hbGx5LCB0aGlzIGlz IHRoZSBiZWhhdmlvciB0aGF0IGlzIGFscmVhZHkgcHJlc2VudCBpbiAiRk9SIEFMTCANClRB QkxFUyI6DQoNCiJNYXJrcyB0aGUgcHVibGljYXRpb24gYXMgb25lIHRoYXQgcmVwbGljYXRl cyBjaGFuZ2VzIGZvciBhbGwgdGFibGVzIGluIA0KdGhlIGRhdGFiYXNlLCBpbmNsdWRpbmcg dGFibGVzIGNyZWF0ZWQgaW4gdGhlIGZ1dHVyZS4iWzEwXQ0KDQpJIGRvbid0IHRoaW5rIHdl IHNob3VsZCBjaGFuZ2UgdGhpcyBiZWhhdmlvciB0aGF0J3MgYWxyZWFkeSBpbiBsb2dpY2Fs IA0KcmVwbGljYXRpb24uIFdoaWxlIEkgdW5kZXJzdGFuZCB0aGUgcmVhc29ucyB3aHkgIkdS QU5UIC4uLiBBTEwgVEFCTEVTIElOIA0KU0NIRU1BIiBoYXMgYSBkaWZmZXJlbnQgYmVoYXZp b3IgKGkuZS4gaXQncyBub3QgYXBwbGllZCB0byBmdXR1cmUgDQpvYmplY3RzKSBhbmQgZG8g bm90IGFkdm9jYXRlIHRvIGNoYW5nZSBpdCwgSSBoYXZlIHBlcnNvbmFsbHkgYmVlbiANCmFm ZmVjdGVkIHdoZXJlIEkgdGhvdWdodCBhIHBlcm1pc3Npb24gd291bGQgYmUgYXBwbGllZCB0 byBhbGwgZnV0dXJlIA0Kb2JqZWN0cywgb25seSB0byBkaXNjb3ZlciBvdGhlcndpc2UuIEkg YmVsaWV2ZSBpdCdzIG1vcmUgaW50dWl0aXZlIHRvIA0KdGhpbmsgdGhhdCAiQUxMIiBhcHBs aWVzIHRvICJldmVyeXRoaW5nLCBhbHdheXMuIg0KDQpGb3IgIzMgKG1vcmUgc3VwZXJ1c2Vy LW9ubHkpLCBpbiBnZW5lcmFsIEkgZG8gYWdyZWUgdGhhdCB3ZSBzaG91bGRuJ3QgYmUgDQph ZGRpbmcgbW9yZSBvZiB0aGVzZS4gSG93ZXZlciwgd2UgaGF2ZSBpbiB0aGlzIHJlbGVhc2Us IGFuZCBub3QganVzdCB0byANCnRoaXMgZmVhdHVyZS4gQUxURVIgU1VCU0NSSVBUSU9OIC4u LiBTS0lQWzExXSByZXF1aXJlcyBzdXBlcnVzZXIuIEkgDQp0aGluayBpdCdzIGVhc2llciBm b3IgdXMgdG8gInJlbGF4IiBwcml2aWxlZ2VzIChlLmcuIHcvcHJlZGVmaW5lZCByb2xlcykg DQp0aGFuIHRvIG1ha2Ugc29tZXRoaW5nICJzdXBlcnVzZXItb25seSIgaW4gdGhlIGZ1dHVy ZSwgc28gSSBkb24ndCBzZWUgDQp0aGlzIGJlaW5nIGEgYmxvY2tlciBmb3IgdjE1LiBUaGUg ZmVhdHVyZSB3aWxsIGNvbnRpbnVlIHRvIHdvcmsgZm9yIA0KdXNlcnMgZXZlbiBpZiB3ZSBy ZW1vdmUgInN1cGVydXNlci1vbmx5IiBpbiB0aGUgZnV0dXJlLg0KDQpUbyBzdW1tYXJpemU6 DQoNCjEuIEkgZG8gdGhpbmsgd2Ugc2hvdWxkIGZpeCB0aGUgaXNzdWUgdGhhdCBQZXRlciBv cmlnaW5hbGx5IGJyb3VnaHQgdXAgDQppbiB0aGlzIHRocmVhZCBiZWZvcmUgdjE1LiBUaGF0 IGlzIGFuIG9wZW4gaXRlbS4NCjIuIEkgZG9uJ3Qgc2VlIHdoeSB3ZSBuZWVkIHRvIGNoYW5n ZSB0aGUgc3ludGF4L2JlaGF2aW9yLCBJIHRoaW5rIHRoYXQgDQp3aWxsIG1ha2UgdGhpcyBm ZWF0dXJlIG11Y2ggaGFyZGVyIHRvIHVzZS4NCjMuIEkgZG9uJ3QgdGhpbmsgd2UgbmVlZCB0 byBjaGFuZ2UgdGhlIHN1cGVydXNlciByZXF1aXJlbWVudCByaWdodCBub3csIA0KYnV0IHdl IHNob3VsZCBkbyB0aGF0IGZvciBhIGZ1dHVyZSByZWxlYXNlLg0KDQpUaGFua3MsDQoNCkpv bmF0aGFuDQoNClsxXSANCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQv Q0FGaVROLXVfbTBjcTdSbTVCY3U5RVc0Z1NIRzk0V2FMdXhMZmlid0UtbzclMkJMZWEyR1El NDBtYWlsLmdtYWlsLmNvbQ0KWzJdIA0KaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVz c2FnZS1pZC9DNEQwNEI5MC1BQzRELTQyQTctQjkzQy00Nzk5Q0VEREREOTYlNDBlbnRlcnBy aXNlZGIuY29tDQpbM10gaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC8x NTU1NjUuMTYyODk1NDU4MCU0MHNzcy5wZ2gucGEudXMNCls0XSANCmh0dHBzOi8vd3d3LnBv c3RncmVzcWwub3JnL21lc3NhZ2UtaWQvQ0FIdXQlMkJQdk53enAtRWR0c0ROYXp3ck5yVjR6 aXFDb3ZOZEx5d3pPSktTeTUyTHZSanclNDBtYWlsLmdtYWlsLmNvbQ0KWzVdIA0KaHR0cHM6 Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9DQUh1dCUyQlB0NkN6ajBLc0UwaXA2 bk1zUGY0RmF0SGdORG5pLXdTdTJLa1lOWUY5bURBdyU0MG1haWwuZ21haWwuY29tDQpbNl0g DQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL0NBQTRlSzFMd3RlYTBT dDFNVjVuZlNnOUZyRmVVMDRZS3BIdmhRMGk0Vy10T0J3JTNEOVF3JTQwbWFpbC5nbWFpbC5j b20NCls3XSANCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQvMjAyMTA5 MjQxMzI1LmVhZzVnNm1wdm91cEBhbHZoZXJyZS5wZ3NxbA0KWzhdIA0KaHR0cHM6Ly93d3cu cG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9DQUxEYU5tMUJFWHR2ZyUzRGZxOEZ6TS1Gb1l2 RVRURXV2QV9HZjhyQ0FqRnIxVnJCNWFCQSU0MG1haWwuZ21haWwuY29tDQpbOV0gDQpodHRw czovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL0NBSmNPZi1meU0zMDc1dDklMkIl M0RCLUJTRnoyRkclM0Q1Qm5EU1BYNFl0TDhrMW5uSyUzRHdqZ1dBJTQwbWFpbC5nbWFpbC5j b20NClsxMF0gaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy9jdXJyZW50L3NxbC1j cmVhdGVwdWJsaWNhdGlvbi5odG1sDQpbMTFdIGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3Jn L2RvY3MvMTUvc3FsLWFsdGVyc3Vic2NyaXB0aW9uLmh0bWwNCg0K --------------hmSyzTa0X8YubqPe3dAM5H68-- --------------sBsSZMyxCBKquyyFbG4Fx20z 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/x8QSccp8cZScFAmMpLYoFAwAAAAAACgkQ8QSccp8cZScS DA/9HRWaZ/cNJxOFXkANA7ZB/xAGoyXu32NC4ZX8rN9/5ANZU+Zh33aulypWIIEzDtpN1oSZvbXq Yl1n0bqyKLb58V/b2gl1eqgDIp5GiGNynCgkSIc2iX9y0bxOKuKlWiscilY1YyBOpp1ypGapMO4N rjHe7eFClGJ/AOJFHOVaDVo94tu8qhLGFkrHNoAHIBYD4xJD2lJZuc6a+pxpKX8XK6DnwZFdwKIj ehmCIgdgeJ+JNn7XYmqSUjTfNpPyEW+AcwgnMb3KNR2k1mcUc17bLUKtSrzhC6JHr+pC4QLCpXSf htnYbDndiJ1oXRnlJfoLRIwDFE5V0vbKhB+L8M72Jg18b9jxryvWqFkkiISlvBcvLWx85x7YPPza M8V0NMOwA6Ja9ZS3ob16Qo2Mm/hO2DHefqnXok0BT+uf0f1yEBQ3grXZRsRe7S6meJC5n1xCM5dy 5lu6golDEKLcSSYmvb/+V7ASl6o2S77S4YWqMf0oxMM4LXWsmzxNlmHomG7UqXdVEbtdmTOjgIT9 eTJRDBtnhgb41Bw18FvQrYhBQWgwVTNIlwLhUBLgAwjPJPbMetzpNo49JL4nkY0Gyu9pH84LcntA yjHs9fPk0jE5SBJ2174gFhMLr0Emj/CsnU0luFjNEzbqhIgN5f0lzXXifer9PVZBJVTJmSW6Y1eK fts= =N/KJ -----END PGP SIGNATURE----- --------------sBsSZMyxCBKquyyFbG4Fx20z--