Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rJIxx-00CbsY-Dm for pgsql-admin@arkaria.postgresql.org; Fri, 29 Dec 2023 19:56:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rJIxw-00Bkpo-0k for pgsql-admin@arkaria.postgresql.org; Fri, 29 Dec 2023 19:56:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rJIxv-00Bkpg-Lq for pgsql-admin@lists.postgresql.org; Fri, 29 Dec 2023 19:56:19 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rJIxt-00Cnsc-3M for pgsql-admin@postgresql.org; Fri, 29 Dec 2023 19:56:18 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 8AD40380567; Fri, 29 Dec 2023 20:56:13 +0100 (CET) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id sPJChorWQpSa; Fri, 29 Dec 2023 20:56:13 +0100 (CET) Received: from [192.168.178.86] (xdsl-84-44-129-210.nc.de [84.44.129.210]) by rs.plausibolo.de (Postfix) with ESMTPSA id 2029D38046D; Fri, 29 Dec 2023 20:56:13 +0100 (CET) Message-ID: <03181d25-d2ee-b638-a285-0986dee1ab60@jakobs.com> Date: Fri, 29 Dec 2023 20:56:12 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Subject: Re: Domain checks not always working when used in compound type Content-Language: de-DE To: Tom Lane Cc: "[PGSQL-ADMIN-LIST]" References: <3236280.1703879366@sss.pgh.pa.us> From: Holger Jakobs In-Reply-To: <3236280.1703879366@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------s3IF3kIXvEdI2AcIuIDKj0vX" 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) --------------s3IF3kIXvEdI2AcIuIDKj0vX Content-Type: multipart/mixed; boundary="------------36JzKNGxoP4NcaRKPG47Dfks"; protected-headers="v1" From: Holger Jakobs To: Tom Lane Cc: "[PGSQL-ADMIN-LIST]" Message-ID: <03181d25-d2ee-b638-a285-0986dee1ab60@jakobs.com> Subject: Re: Domain checks not always working when used in compound type References: <3236280.1703879366@sss.pgh.pa.us> In-Reply-To: <3236280.1703879366@sss.pgh.pa.us> --------------36JzKNGxoP4NcaRKPG47Dfks Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMjkuMTIuMjMgdW0gMjA6NDkgc2NocmllYiBUb20gTGFuZToNCj4gSG9sZ2VyIEpha29i cyA8aG9sZ2VyQGpha29icy5jb20+IHdyaXRlczoNCj4+IC0tIFVzaW5nIHRoZSBkb21haW4g d2l0aGluIGEgY29tcG91bmQgdHlwZS4gVGhlIE5PVCBOVUxMIGNvbnN0cmFpbnQNCj4+IHNo b3VsZCBiZQ0KPj4gLS0gaW5oZXJpdGVkIGZyb20gdGhlIGRvbWFpbiwgdGhlcmVmb3JlIG5v dCByZXBlYXRlZCBoZXJlIGZvciBjb2x1bW4gYS4NCj4+IENSRUFURSBUWVBFIGNvbXBvdW5k X2FiIEFTICgNCj4+ICAgwqAgYcKgwqDCoCBkb21haW5fYSwNCj4+ICAgwqAgYsKgwqDCoCB2 YXJjaGFyKDEwKQ0KPj4gKTsNCj4gWW91IGFyZSBhc3N1bWluZyBpbiBlZmZlY3QgdGhhdCBh IHNpbXBsZSBOVUxMIHZhbHVlIGZvciBhIGNvbXBvc2l0ZQ0KPiB0eXBlIGlzIHRoZSBzYW1l IHRoaW5nIGFzIFJPVyhOVUxMLCBOVUxMKS4gIFRoZXkgYXJlIG5vdCBxdWl0ZSB0aGUNCj4g c2FtZSwgYW5kIG9uZSB3YXkgaW4gd2hpY2ggdGhleSBhcmUgbm90IGlzIHRoYXQgd2UgZG9u J3QgY29uc2lkZXINCj4gZmllbGQtbGV2ZWwgY29uc3RyYWludHMgd2hlbiBkZWNpZGluZyBp ZiBhIHNpbXBsZSBOVUxMIHZhbHVlIGlzIGxlZ2FsDQo+IGZvciB0aGUgY29tcG9zaXRlIC0t IGl0IGFsd2F5cyBpcy4gIFRodXMNCj4NCj4gcmVncmVzc2lvbj0jIHNlbGVjdCBudWxsOjpj b21wb3VuZF9hYjsNCj4gICBjb21wb3VuZF9hYg0KPiAtLS0tLS0tLS0tLS0tDQo+ICAgDQo+ ICgxIHJvdykNCj4NCj4gcmVncmVzc2lvbj0jIHNlbGVjdCByb3cobnVsbCwgbnVsbCk6OmNv bXBvdW5kX2FiOw0KPiBFUlJPUjogIGRvbWFpbiBkb21haW5fYSBkb2VzIG5vdCBhbGxvdyBu dWxsIHZhbHVlcw0KPg0KPiBUaGUgU1FMIHNwZWMgaXRzZWxmIGlzIHByZXR0eSBzY2hpem9w aHJlbmljIGFib3V0IHdoZXRoZXIgUk9XKE5VTEwsIE5VTEwpDQo+IGlzIGVxdWl2YWxlbnQg dG8gYmFyZSBOVUxMLiAgVGhpcyBpcyBob3cgd2UndmUgY2hvc2VuIHRvIGludGVycHJldCBp dC4NCj4gSSdsbCBmcmVlbHkgYWRtaXQgdGhhdCB0aGVyZSdzIHNvbWUgaW1wbGVtZW50YXRp b24gY29uc2lkZXJhdGlvbnMNCj4gaW52b2x2ZWQgaW4gdGhhdCBjaG9pY2UsIGJ1dCB3ZSdy ZSB1bmxpa2VseSB0byByZXZpc2l0IGl0Lg0KPg0KPiBJZiB5b3UgZG9uJ3Qgd2FudCB0aGlu Z3MgdG8gd29yayBsaWtlIHRoaXMsIHlvdSBjb3VsZCBhdHRhY2ggYSBOT1QNCj4gTlVMTCBj b25zdHJhaW50IHRvIHRoZSB0ZXN0MS5hYiBjb2x1bW4gKGFzIHdlbGwgYXMgaGF2aW5nIHRo ZSBkb21haW4NCj4gY29uc3RyYWludCkuDQo+DQo+IAkJCXJlZ2FyZHMsIHRvbSBsYW5lDQoN CkNSRUFURSBUQUJMRSB0ZXN0MSAoDQogwqAgbmFtZcKgIFZBUkNIQVIoMjUpIE5PVCBOVUxM IFVOSVFVRSwNCiDCoCBhYsKgwqDCoCBjb21wb3VuZF9hYiBOT1QgTlVMTCwNCiDCoCBpZMKg wqDCoCBJTlRFR0VSIEdFTkVSQVRFRCBBTFdBWVMgQVMgSURFTlRJVFkNCik7DQoNCklOU0VS VCBJTlRPIHRlc3QxIFZBTFVFUyAoJ3BlcnNvbjEnKTsNCklOU0VSVCAwIDENCkVSUk9SIDIz NTAyOiBOVUxMIHZhbHVlIGluIGNvbHVtbiAiYWIiIG9mIHJlbGF0aW9uICJ0ZXN0MSIgdmlv bGF0ZXMgTk9UIA0KTlVMTCBjb25zdHJhaW50DQoNClRoYXQgb25lIGlzIGZpbmUgbm93LiBU aGFua3MgZm9yIHRoZSBleHBsYW5hdGlvbi4NCg0KDQpPVE9ILCB0aGUgc2Vjb25kIHByb2Js ZW0gcGVyc2lzdHMuDQoNCklOU0VSVCBJTlRPIHRlc3QxIChuYW1lLCBhYi5iKQ0KIMKgIFZB TFVFUyAoJ3BlcnNvbjMnLCAnc29tZXRoaW5nJyk7DQpJTlNFUlQgMCAxDQoNClNFTEVDVCAq LCAoYWIpLmEgRlJPTSB0ZXN0MTsNCiDCoCBuYW1lwqDCoCB8wqDCoMKgwqDCoCBhYsKgwqDC oMKgwqAgfCBpZCB8IGENCi0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0tKy0tLQ0KIMKg cGVyc29uMyB8ICgsc29tZXRoaW5nKSB8wqAgMiB8IMKkDQoNCkNhbiBzb21ldGhpbmcgYmUg ZG9uZSBhYm91dCB0aGlzIG9uZT8NCg0KUmVnYXJkcywNCg0KSG9sZ2VyDQoNCg0KLS0gDQoN CkhvbGdlciBKYWtvYnMsIEJlcmdpc2NoIEdsYWRiYWNoLCBUZWwuICs0OS0xNzgtOTc1OTAx Mg0KDQo= --------------36JzKNGxoP4NcaRKPG47Dfks-- --------------s3IF3kIXvEdI2AcIuIDKj0vX Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZY8kXAUDAAAAAAAKCRCKV5yTsxlhuhU7 AJ4xIsWQOEu9S5EZnA3NsZNkUb5/4wCfSaB95tuwe6HX1TVzQ9CLzSU+1jw= =lclU -----END PGP SIGNATURE----- --------------s3IF3kIXvEdI2AcIuIDKj0vX--