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 1oajBn-0001je-Nk for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Sep 2022 19:45:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oajBm-0002w6-2w for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Sep 2022 19:45:50 +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 1oajBl-0002vx-LD for pgsql-hackers@lists.postgresql.org; Tue, 20 Sep 2022 19:45:49 +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 1oajBi-00025F-M9 for pgsql-hackers@postgresql.org; Tue, 20 Sep 2022 19:45:48 +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=IhXm+pOpKgZ/EXaC5gZzQ8smIvYvgLeiT7ogjiXL8Vg=; b=xAoAleF6MoQOJPiMwQWrxOp73J 1ML+9v+BxnvrZBAfhqCWjj+ND9y4O3L18SGfFrUJP5gaJ00TPZ/w4Gv4WL6T3HnaODbyCKarVYRky xG+JROQGxvDKXcduYMGs4Y5D/yoOvhoCoz8PcNNsi5uXVdtWZT6MxwvDt8Ym2NSuekaaEhhhsEN21 h/AWUyDp+QR74WqhXpF5iDhfg/HqHWjz8j7BZVU6C84BBJNEt3QtGhdwPVDD7ZfBQnshRSoKVbLNO rpe8HARosmdg8rGNsyohlJf6MfVjAV9kRSbFSE9CxkQEAnbBRZnbMb0VI5bEH1gSxYbRjKkCypfd4 uBgqwFFg==; 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 1oajBb-0008S4-Qe; Tue, 20 Sep 2022 19:45:42 +0000 Message-ID: <93d52613-11d9-7fc7-d2b1-856205b8d6b6@postgresql.org> Date: Tue, 20 Sep 2022 15:45:37 -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: Robert Haas Cc: Alvaro Herrera , "houzj.fnst@fujitsu.com" , Amit Kapila , vignesh C , 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="------------j7JgZV0lXUyMlFDg1lyJx1Zy" 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) --------------j7JgZV0lXUyMlFDg1lyJx1Zy Content-Type: multipart/mixed; boundary="------------kvILcxU1LkCih0hUOxhEjTb0"; protected-headers="v1" From: "Jonathan S. Katz" To: Robert Haas Cc: Alvaro Herrera , "houzj.fnst@fujitsu.com" , Amit Kapila , vignesh C , Tom Lane , pgsql-hackers , Peter Eisentraut Message-ID: <93d52613-11d9-7fc7-d2b1-856205b8d6b6@postgresql.org> 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: --------------kvILcxU1LkCih0hUOxhEjTb0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 KFJNVCBoYXQgb24sIHVubGVzcyBvdGhlcndpc2Ugbm90ZWQpDQoNCk9uIDkvMjAvMjIgOTo0 MiBBTSwgUm9iZXJ0IEhhYXMgd3JvdGU6DQo+IE9uIE1vbiwgU2VwIDE5LCAyMDIyIGF0IDEx OjAzIFBNIEpvbmF0aGFuIFMuIEthdHogPGprYXR6QHBvc3RncmVzcWwub3JnPiB3cm90ZToN Cj4+IEZvciAjMSAoYWxsb3dpbmcgY2FsbHMgdGhhdCBoYXZlIHNjaGVtYS90YWJsZSBvdmVy bGFwLi4uKSwgdGhlcmUgYXBwZWFycw0KPj4gdG8gYmUgYm90aCBhIHBhdGNoIHRoYXQgYWxs b3dzIHRoaXMgKHJldmVyc2luZ1s4XSksIGFuZCBhIHN1Z2dlc3Rpb24gZm9yDQo+PiBkZWFs aW5nIHdpdGggYSBjb3JuZXItY2FzZSB0aGF0IGlzIHJlYXNvbmFibGUsIGkuZS4gZGlzYWxs b3dpbmcgYWRkaW5nDQo+PiBzY2hlbWFzIHRvIGEgcHVibGljYXRpb24gd2hlbiBzcGVjaWZ5 aW5nIGNvbHVtbi1saXN0cy4gRG8gd2UgdGhpbmsgd2UNCj4+IGNhbiBoYXZlIGNvbnNlbnN1 cyBvbiB0aGlzIHByaW9yIHRvIHRoZSBSQzEgZnJlZXplPw0KPiANCj4gSSBhbSBub3Qgc3Vy ZSB3aGV0aGVyIHdlIGNhbiBvciBzaG91bGQgcnVzaCBhIGZpeCBpbiB0aGF0IGZhc3QsIGJ1 dCBJDQo+IGFncmVlIHdpdGggdGhpcyBkaXJlY3Rpb24uDQoNClRoZSBSTVQgbWV0IHRvZGF5 IHRvIGRpc2N1c3MgdGhpcy4NCg0KV2UgZGlkIGFncmVlIHRoYXQgdGhlIGFib3ZlIGlzIGFu IG9wZW4gaXRlbSB0aGF0IHNob3VsZCBiZSByZXNvbHZlZCANCmJlZm9yZSB0aGlzIHJlbGVh c2UuIFdoaWxlIGl0IGlzIGFuIGFjY2VwdGVkIHBhdHRlcm4gZm9yIHVzIHRvICJFUlJPUiIg DQpvbiB1bnN1cHBvcnRlZCBiZWhhdmlvciBhbmQgdGhlbiBsYXRlciBpbnRyb2R1Y2Ugc2Fp ZCBiZWhhdmlvciwgd2UgZG8gDQphZ3JlZSB3aXRoIFBldGVyJ3Mgb3JpZ2luYWwgcG9zdCBp biB0aGlzIHRocmVhZCBhbmQgd291bGQgbGlrZSBpdCByZXNvbHZlZC4NCg0KQXMgZm9yIHRo ZSBzdGF0ZSBvZiB0aGUgZml4LCB0aGUgcGF0Y2ggaGFzIGJlZW4gaXRlcmF0ZWQgb24gYW5k IEFtaXQgDQpmZWx0IHJlYWR5IHRvIGNvbW1pdCBpdFsxXS4gV2UgZG8gd2FudCB0byBoZWFy IGhvdyBvdGhlcnMgZmVlbCBhYm91dCANCnRoaXMsIGJ1dCB0aGUgZm9sa3MgYmVoaW5kIHRo aXMgZmVhdHVyZSBoYXZlIGJlZW4gd29ya2luZyBvbiB0aGlzIHBhdGNoIA0Kc2luY2UgdGhp cyB3YXMgcmVwb3J0ZWQuDQoNCj4+IEZvciAjMiAoIkFMTCBUQUJMRVMgSU4gU0NIRU1BIiBz eW50YXgpLCB0aGlzIHdhcyBoZWF2aWx5IGRpc2N1c3NlZCBvbg0KPj4gdGhlIG9yaWdpbmFs IHRocmVhZFsxXVszXVs0XVs1XVs3XS4gSSB0aG91Z2h0IFRvbSdzIHByb3Bvc2FsIG9uIHRo ZQ0KPj4gc3ludGF4WzNdIHdhcyByZWFzb25hYmxlIGFzIGl0ICJmdXR1cmUgcHJvb2ZzIiBm b3Igd2hlbiB3ZSBhbGxvdyBvdGhlcg0KPj4gc2NoZW1hLXNjb3BlZCBvYmplY3RzIHRvIGJl IHB1Ymxpc2hlZCBhbmQgZ2l2ZSBjb250cm9sIG92ZXIgd2hpY2ggb25lcw0KPj4gY2FuIGJl IHB1Ymxpc2hlZC4NCj4gDQo+IEFsbCByaWdodCwgd2VsbCwgSSBzdGlsbCBkb24ndCBsaWtl IGl0IGFuZCB0aGluayBpdCdzIGNvbmZ1c2luZywgYnV0DQo+IHBlcmhhcHMgSSdtIGluIHRo ZSBtaW5vcml0eS4NCg0KVGhlIFJNVCBkaXNjdXNzZWQgdGhpcyBhcyB3ZWxsLiBUaGUgUk1U IGZlZWxzIHRoYXQgdGhlcmUgc2hvdWxkIG5vdCBiZSANCmFueSBjaGFuZ2VzIHRvIHN5bnRh eC9iZWhhdmlvciBmb3IgdGhpcyByZWxlYXNlLiBUaGlzIGRvZXNuJ3QgcHJlY2x1ZGUgDQpm dXR1cmUgd29yayBpbiB0aGlzIGFyZWEgKGUuZy4gaGF2aW5nIGEgdG9nZ2xlIGZvciAiYWxs IGZ1dHVyZSANCmJlaGF2aW9yIiksIGJ1dCBiYXNlZCBvbiBhbGwgdGhlIGRpc2N1c3Npb25z IGFuZCBleGlzdGluZyBiZWhhdmlvciBpbiANCnRoaXMgZmVhdHVyZSwgd2UgZG8gbm90IHNl ZSBhIG5lZWQgdG8gbWFrZSBjaGFuZ2VzIG9yIGRlbGF5IHRoZSByZWxlYXNlIA0Kb24gdGhp cy4NCg0KPj4gSSBkb24ndCB0aGluayB3ZSBzaG91bGQgY2hhbmdlIHRoaXMgYmVoYXZpb3Ig dGhhdCdzIGFscmVhZHkgaW4gbG9naWNhbA0KPj4gcmVwbGljYXRpb24uIFdoaWxlIEkgdW5k ZXJzdGFuZCB0aGUgcmVhc29ucyB3aHkgIkdSQU5UIC4uLiBBTEwgVEFCTEVTIElODQo+PiBT Q0hFTUEiIGhhcyBhIGRpZmZlcmVudCBiZWhhdmlvciAoaS5lLiBpdCdzIG5vdCBhcHBsaWVk IHRvIGZ1dHVyZQ0KPj4gb2JqZWN0cykgYW5kIGRvIG5vdCBhZHZvY2F0ZSB0byBjaGFuZ2Ug aXQsIEkgaGF2ZSBwZXJzb25hbGx5IGJlZW4NCj4+IGFmZmVjdGVkIHdoZXJlIEkgdGhvdWdo dCBhIHBlcm1pc3Npb24gd291bGQgYmUgYXBwbGllZCB0byBhbGwgZnV0dXJlDQo+PiBvYmpl Y3RzLCBvbmx5IHRvIGRpc2NvdmVyIG90aGVyd2lzZS4gSSBiZWxpZXZlIGl0J3MgbW9yZSBp bnR1aXRpdmUgdG8NCj4+IHRoaW5rIHRoYXQgIkFMTCIgYXBwbGllcyB0byAiZXZlcnl0aGlu ZywgYWx3YXlzLiINCj4gDQo+IE5haCwgdGhlcmUncyByb29tIGZvciBtdWx0aXBsZSBiZWhh dmlvcnMgaGVyZS4gSXQncyByZWFzb25hYmxlIHRvIHdhbnQNCj4gdG8gYWRkIGFsbCB0aGUg dGFibGVzIGN1cnJlbnRseSBpbiB0aGUgc2NoZW1hIHRvIGEgcHVibGljYXRpb24gKG9yDQo+ IGdyYW50IHBlcm1pc3Npb25zIG9uIHRoZW0pIGFuZCBpdCdzIHJlYXNvbmFibGUgdG8gd2Fu dCB0byBpbmNsdWRlIGFsbA0KPiBjdXJyZW50IGFuZCBmdXR1cmUgdGFibGVzIGluIHRoZSBz Y2hlbWEgaW4gYSBwdWJsaWNhdGlvbiAob3IgZ3JhbnQNCj4gcGVybWlzc2lvbnMgb24gdGhl bSkgdG9vLiBUaGUgcmVhc29uIEkgZG9uJ3QgbGlrZSB0aGUgQUxMIFRBQkxFUyBJTg0KPiBT Q0hFTUEgc3ludGF4IGlzIHRoYXQgaXQgc291bmRzIGxpa2UgdGhlIGZvcm1lciwgYnV0IGFj dHVhbGx5IGlzIHRoZQ0KPiBsYXR0ZXIuIEJhc2VkIG9uIHlvdXIgbGluayB0byB0aGUgZW1h aWwgZnJvbSBUb20sIEkgdW5kZXJzdGFuZCBub3cgdGhlDQo+IHJlYXNvbiB3aHkgaXQncyBs aWtlIHRoYXQsIGJ1dCBpdCdzIHN0aWxsIGNvdW50ZXJpbnR1aXRpdmUgdG8gbWUuDQoNCjxQ ZXJzb25hbE9waW5pb24+DQpJIHVuZGVyc3RhbmQgeW91ciB2aWV3IG9uICJtdWx0aXBsZSBi ZWhhdmlvcnMiIGFuZCBJIGRvIGFncmVlIHdpdGggeW91ciANCnJlYXNvbmluZy4gSSBzdGls bCB0aGluayB3ZSBzaG91bGQgbGVhdmUgdGhpcyBhcyBpcywgYnV0IHBlcmhhcHMgdGhpcyAN Cm9wZW5zIHVwIGFuIG9wdGlvbiB3ZSBhZGQgbGF0ZXIgdG8gc3BlY2lmeSB0aGUgYmVoYXZp b3IuDQo8L1BlcnNvbmFsT3Bpbmlvbj4NCg0KPiANCj4+IEZvciAjMyAobW9yZSBzdXBlcnVz ZXItb25seSksIGluIGdlbmVyYWwgSSBkbyBhZ3JlZSB0aGF0IHdlIHNob3VsZG4ndCBiZQ0K Pj4gYWRkaW5nIG1vcmUgb2YgdGhlc2UuIEhvd2V2ZXIsIHdlIGhhdmUgaW4gdGhpcyByZWxl YXNlLCBhbmQgbm90IGp1c3QgdG8NCj4+IHRoaXMgZmVhdHVyZS4gQUxURVIgU1VCU0NSSVBU SU9OIC4uLiBTS0lQWzExXSByZXF1aXJlcyBzdXBlcnVzZXIuIEkNCj4+IHRoaW5rIGl0J3Mg ZWFzaWVyIGZvciB1cyB0byAicmVsYXgiIHByaXZpbGVnZXMgKGUuZy4gdy9wcmVkZWZpbmVk IHJvbGVzKQ0KPj4gdGhhbiB0byBtYWtlIHNvbWV0aGluZyAic3VwZXJ1c2VyLW9ubHkiIGlu IHRoZSBmdXR1cmUsIHNvIEkgZG9uJ3Qgc2VlDQo+PiB0aGlzIGJlaW5nIGEgYmxvY2tlciBm b3IgdjE1LiBUaGUgZmVhdHVyZSB3aWxsIGNvbnRpbnVlIHRvIHdvcmsgZm9yDQo+PiB1c2Vy cyBldmVuIGlmIHdlIHJlbW92ZSAic3VwZXJ1c2VyLW9ubHkiIGluIHRoZSBmdXR1cmUuDQo+ IA0KPiBZZWFoLCB0aGlzIGlzIGNsZWFybHkgbm90IGEgcmVsZWFzZSBibG9ja2VyLCBJIHRo aW5rLg0KDQpUaGUgUk1UIGNvbmN1cnMuIFdlIGRvIHJlY29tbWVuZCBmdXR1cmUgd29yayBv biAicmVsYXhpbmciIHRoZSANCnN1cGVydXNlci1vbmx5IHJlcXVpcmVtZW50Lg0KDQpUaGFu a3MsDQoNCkpvbmF0aGFuDQoNClsxXSANCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21l c3NhZ2UtaWQvQ0FBNGVLMUxEaG9CTThLNXVWbWU4UFolMkJreE5PZlZwUmglM0RvTzQySnRG ZHFCZ0J1ajFiQSU0MG1haWwuZ21haWwuY29tDQo= --------------kvILcxU1LkCih0hUOxhEjTb0-- --------------j7JgZV0lXUyMlFDg1lyJx1Zy 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/x8QSccp8cZScFAmMqGGEFAwAAAAAACgkQ8QSccp8cZSfA Iw//YycG21FpET9DGrNnZam5mRtsNVSTwo1xs5XJVW9tzXcNUH6Hq3hkGDKb43NHriEsMq8k8wEr +QelyAZ4kxCurR6dpQU5KD68WuRXAgzILsFkvqR1XJ53WDRF4ocilAPJ9U2YnBEzev9gwo3SSLBc mVaadEQS1vJzONxh8LEuVuWzO8n3zuOKPlQUu/7cfd5gUlUYS5J8LATGCq8k6y2KQDK+lQWh8ny6 B/ex6/yo1XQrSUiT5QB40UVadOivW7DJ/CZ3Lnqcm/MJodx4ceBvip1+VBJj48SX7CGFqqZKJkJu nAfzVM5h06U2657d6ZNNA3JUzV/X9qLOUT72d17xdc+Q0eh6zhQ7Z8X2u0htCAS9V7bix+8FjUy2 vKu/8Yz7zJ/AGH3AR3xCSGgsOVH7t1OX5CcgnHwZhjJeYuFBI9+XWZ1QYep1Pnb5ToBh4/HvYnXt +v0URP6/8CyQUasQMZZKLTtUGJm5rh2A26P+G5Graf0sbzR2jyonH9sq2bot1xOtS7QUv5Bfvw28 /79+Yu94Vc+qt5ywDJGO+MMgJO6nK3AjT376IE91erOnZGnVzeLYTTHZ88C90W++TsIAZ8a6xbqj ler5poJMoGDA1RJmVLMz08LZQ87VwY5C1rZNGjOA/xpC3YpPOLxpwxUATWlWQUdwOtaVFOWAjof8 NF0= =fxZd -----END PGP SIGNATURE----- --------------j7JgZV0lXUyMlFDg1lyJx1Zy--