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 1oapHi-0000po-Mx for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2022 02:16:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oapHh-0007bP-JE for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2022 02:16: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 1oapHh-0007bD-5r for pgsql-hackers@lists.postgresql.org; Wed, 21 Sep 2022 02:16:21 +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 1oapHe-0005BK-Mk for pgsql-hackers@postgresql.org; Wed, 21 Sep 2022 02:16:20 +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=xTtdbFrOvHyzYMndv55cKG2cP9rg1fy2dM/fkFrH54I=; b=qfqs7Bw42zNLIXrp1XAh6Dxc8o QS3htpZb4NKjikOZNp3k4BfwXRInzYXk/tOFs/B/+dsMGkm+kyrjLan2eG03C3BNAbLA4826jNfJ7 A6obFnpEFDqz0dqLRQZu3Ttj2tOpRu7pAkeiTR5nvwGszJlgRiEUQQxV4mYPsaYcLLzZyk6Lup1xi jHDBh8E4WMjUvSkHlcp2pOZG1RL1M3EIH8+9UIagen51rQhO/FobnYa4BYW3+GOZfXlvDQpjMaFW3 vBNP4gSr1cLdc8leAJ4Cnct9TmzwHoKtcIFiocE2oC1jWwBlfKuGWrjmhsBvZd7Btr1cFHRJ+DmZ4 vvoXddFw==; 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 1oapHX-00051T-NA; Wed, 21 Sep 2022 02:16:13 +0000 Message-ID: <40e5b4b1-e3ac-b771-e7e2-009483cbf970@postgresql.org> Date: Tue, 20 Sep 2022 22:16:07 -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> <2C62FF84-453C-4E0E-AFEB-B2D96D641636@enterprisedb.com> From: "Jonathan S. Katz" Subject: Re: why can't a table be part of the same publication as its schema In-Reply-To: <2C62FF84-453C-4E0E-AFEB-B2D96D641636@enterprisedb.com> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------pyQr50TOqT3rQFbZmdtCdMAg" 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) --------------pyQr50TOqT3rQFbZmdtCdMAg Content-Type: multipart/mixed; boundary="------------yiGinorPE3ytBl1ajrsXNldo"; 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: <40e5b4b1-e3ac-b771-e7e2-009483cbf970@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> <2C62FF84-453C-4E0E-AFEB-B2D96D641636@enterprisedb.com> In-Reply-To: <2C62FF84-453C-4E0E-AFEB-B2D96D641636@enterprisedb.com> --------------yiGinorPE3ytBl1ajrsXNldo Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 W3BlcnNvbmFsIHZpZXdzLCBub3QgUk1UXQ0KDQpPbiA5LzIwLzIyIDQ6MDYgUE0sIE1hcmsg RGlsZ2VyIHdyb3RlOg0KDQo+IEkgZG9uJ3QgY29tcGxhaW4gdGhhdCBpdCBpcyBidWlkbGlu ZyBvbiB0aGUgZXhpc3RpbmcgYmVoYXZpb3IuICBJJ20gKm9ubHkqIGNvbmNlcm5lZCBhYm91 dCB0aGUga2V5d29yZHMgd2UncmUgdXNpbmcgZm9yIHRoaXMuICBDb25zaWRlciB0aGUgZm9s bG93aW5nOg0KPiANCj4gICAgIC0tIEFTIEFETUlODQo+ICAgICBDUkVBVEUgVVNFUiBib2Ig Tk9TVVBFUlVTRVI7DQo+ICAgICBHUkFOVCBBTEwgUFJJVklMRUdFUyBPTiBBTEwgVEFCTEVT IElOIFNDSEVNQSBmb28gVE8gYm9iOw0KPiAgICAgU0VUIFJPTEUgYm9iOw0KPiAgICAgQ1JF QVRFIFBVQkxJQ0FUSU9OIGJvYnNfcHViIEZPUiBBTEwgVEFCTEVTIElOIFNDSEVNQSBmb287 DQo+IA0KPiBXZSdyZSBnb2luZyB0byBoYXZlIHRoYXQgZmFpbCBpbiBwZzE1IGJlY2F1c2Ug dGhlIEZPUiBBTEwgVEFCTEVTIElOIFNDSEVNQSBvcHRpb24gaXMgcmVzZXJ2ZWQgdG8gc3Vw ZXJ1c2Vycy4gIEJ1dCB3ZSBhZ3JlZWQgdGhhdCB3YXMgYSBzdG9wLWdhcCBzb2x1dGlvbiB0 aGF0IHdlJ2QgcG90ZW50aWFsbHkgbG9vc2VuIGluIHRoZSBmdXR1cmUuICBDZXJ0YWlubHkg d2UnbGwgbmVlZCB3aWdnbGUgcm9vbSBpbiB0aGUgc3ludGF4IHRvIHBlcmZvcm0gdGhhdCBs b29zZW5pbmc6DQo+IA0KPiAgICAgLS0tIE11c3QgYmUgc3VwZXJ1c2VyIGZvciB0aGlzIGlu IHBnMTUsIGFuZCBpbiBzdWJzZXF1ZW50IHJlbGVhc2VzLg0KPiAgICAgQ1JFQVRFIFBVQkxJ Q0FUSU9OIGJvYnNfcHViIEZPUiBBTEwgRlVUVVJFIFRBQkxFUyBJTiBTQ0hFTUEgZm9vOw0K PiANCj4gICAgIC0tLSBOb3Qgc3VwcG9ydGVkIGluIHBnMTUsIGJ1dCByZXNlcnZlZCBmb3Ig c29tZSBmdXR1cmUgcGcgdmVyc2lvbnMgdG8gYWxsb3cNCj4gICAgIC0tLSBub24tc3VwZXJ1 c2VycyB0byBjcmVhdGUgcHVibGljYXRpb25zIG9uIHRhYmxlcyBjdXJyZW50bHkgaW4gc2No ZW1hIGZvbywNCj4gICAgIC0tLSBhc3N1bWluZyB0aGV5IGhhdmUgc3VmZmljaWVudCBwcml2 aWxlZ2VzIG9uIHRob3NlIHRhYmxlcw0KPiAgICAgQ1JFQVRFIFBVQkxJQ0FUSU9OIGJvYnNf cHViIEZPUiBBTEwgVEFCTEVTIElOIFNDSEVNQSBmb287DQo+IA0KPiBEb2luZyBpdCB0aGlz IHdheSBtYWtlcyB0aGUgc3ludGF4IGNvbnNpc3RlbnQgYmV0d2VlbiB0aGUgR1JBTlQuLi5U TyBib2IgYW5kIHRoZSBDUkVBVEUgUFVCTElDQVRJT04gYm9ic19wdWIuICBTdXJlbHkgdGhp cyBtYWtlcyBtb3JlIHNlbnNlPw0KDQpXaGVuIHlvdSBwdXQgaXQgdGhhdCB3YXksIEkgc2Vl IHlvdXIgcG9pbnQuIEhvd2V2ZXIsIGZvciB0aGUgDQpsZXNzZXItcHJpdmlsZWdlZCB1c2Vy IHRob3VnaCwgd2lsbCB0aGUgYmVoYXZpb3IgYmUgdGhhdCBpdCB3aWxsIA0KY29udGludWUg dG8gYWRkIGFsbCBmdXR1cmUgdGFibGVzIGluIGEgc2NoZW1hIHRvIHRoZSBwdWJsaWNhdGlv biBzbyBsb25nIA0KYXMgdGhleSBoYXZlIHN1ZmZpY2llbnQgcHJpdmlsZWdlcyBvbiB0aG9z ZSB0YWJsZXM/IE9yIHdvdWxkIHRoYXQgbWlycm9yIA0KdGhlIGN1cnJlbnQgYmVoYXZpb3Ig d2l0aCBHUkFOVD8NCg0KV2hpbGUgSSB1bmRlcnN0YW5kIGl0IG1ha2VzIGl0IGNvbnNpc3Rl bnQsIHRoZSBvbmUgY29uY2VybiBJIHJhaXNlIGlzIA0KdGhhdCBpdCBtZWFucyB0aGUgbGVz cyBwcml2aWxlZ2VkIHVzZXIgY291bGQgaGF2ZSBhIGxlc3MgY29udmVuaWVudCB1c2VyIA0K ZXhwZXJpZW5jZSB0aGFuIHRoZSBwcml2aWxlZ2VkIHVzZXIuIFBlcmhhcHMgdGhhdCdzIE9L LCBidXQgd29ydGggbm90aW5nLg0KDQo+IEknbSBub3QgYSBodWdlIGZhbiBvZiB0aGUga2V5 d29yZCAiRlVUVVJFIiBoZXJlLCBidXQgSSBmb3VuZCBhIHJlZmVyZW5jZSB0byBhbm90aGVy IGRhdGFiYXNlIHRoYXQgdXNlcyB0aGF0IGtleXdvcmQgZm9yIHdoYXQgSSB0aGluayBpcyBh IHNpbWlsYXIgcHVycG9zZS4NCg0KSSBkaWQgdHJ5IGRvaW5nIHJlc2VhcmNoIG9uIHRoaXMg cHJpb3IsIGJ1dCBoYWRuJ3QgdGhvdWdodCB0byANCmluY29ycG9yYXRlICJmdXR1cmUiIGlu dG8gbXkgc2VhcmNoZXMuDQoNCkRvaW5nIHNvLCBJIHByb2JhYmx5IGZvdW5kIHRoZSBzYW1l IGRhdGFiYXNlIHRoYXQgeW91IGRpZCB0aGF0IHVzZWQgdGhlIA0KIkZVVFVSRSIgd29yZCBm b3IgYWRkaW5nIHBlcm1pc3Npb25zIHRvIGZ1dHVyZSBvYmplY3RzIChhbmQgdGhpcyBpcyAN CmZyZXNoLCBhcyB0aGUgZG9jcyBmb3IgaXQgd2VyZSBwdWJsaXNoZWQgbGFzdCB3ZWVrKS4g VGhhdCdzIGRlZmluaXRlbHkgDQppbnRlcmVzdGluZy4NCg0KSSBkaWQgc2VlIHNvbWUgbm90 ZXMgb24gYSBsZWdhY3kgZGF0YWJhc2Ugc3lzdGVtIHRoYXQgb2ZmZXJlZCBzaW1pbGFyIA0K YWR2aWNlIHRvIHdoYXQgd2UgZG8gZm9yIEdSQU5UIGlmIHlvdSdyZSBub3QgdXNpbmcgQUxU RVIgREVGQVVMVCBQUklWSUxFR0VTLg0KDQo+ICBXZSBzaG91bGQgY2hvb3NlICpzb21ldGhp bmcqIGZvciB0aGlzLCB0aG91Z2gsIGlmIHdlIHdhbnQgdGhpbmdzIHRvIGJlIHJhdGlvbmFs IGdvaW5nIGZvcndhcmQuDQoNClRoYXQgYWxsIHNhaWQsIHdoaWxlIEkgdW5kZXJzdGFuZCB5 b3VyIHBvaW50IGFuZCBvcGVuIHRvIHRoZSBzdWdnZXN0aW9uIA0Kb24gIkZVVFVSRSIsIEkn bSBub3QgY29udmluY2VkIG9uIHRoZSBzeW50YXggY2hhbmdlLiBCdXQgSSdsbCBzbGVlcCBv biBpdC4NCg0KSm9uYXRoYW4NCg== --------------yiGinorPE3ytBl1ajrsXNldo-- --------------pyQr50TOqT3rQFbZmdtCdMAg 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/x8QSccp8cZScFAmMqc+cFAwAAAAAACgkQ8QSccp8cZSc0 +xAAmS6Pbu7FxSRlxSlzE+p5cN1P4j1uycnp+NsP7AMyybQ/S+ncnSU6NNCbQGk6mwoVCmCjDiEv zSe8B4od4/cfV26EEyHHwfB69EHidbP8lCMFv8BDov89S7p/7u80v6sv2lwWy5I7WPwPrpvyAE65 BK0/6sy53FuXhgphd0WqTw72jldO1bmC9hpzoZYlTPBEvFkxNbhhg/TD8ON51M7BmVoK/8G8yDlB VY5AWSB/q6bMBo3FFyroZeZ4o0JFyNHjHD48/h2IAXMjjw+jrLuZ2ln1/gWdBLHI1Vuc9z2DbaS+ erJ+o9MgDJmK4ZMSDpokFK6bOmiM9hVxyuAhudXF/PVnjWetswiQ/4EqoAS3nky1FUsjWFvB1eCU yYuAVcLJYEMs2yXub7NHz+4AG5k6rNSr6cgghOXWKZAE51wKFZI8IPOaxlPxR32YcAkOQ3hnRRRE 1UhpTawJxU0bxGScUpvgsLtb+AS9E4fhwKMiBMQJ0IVn8vwQK7E21g3DpG+E5xz2lfbbBWA7/oK8 /nKzMPh0D25p3w+DHWsWCzTyT4lImo9KChH5Ck6JeO3aEKyWXoUAb2hxopyhUTR6Kf5RxEvLfFwU KRvkEUtfXfJqa5xSDwP6elLAl7L9/JcMiORaqSkx8svzxmJfRe1grkByTyxegn77aAw1OtsdFh8Y TU8= =F1za -----END PGP SIGNATURE----- --------------pyQr50TOqT3rQFbZmdtCdMAg--