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 1q2GLg-0007Km-K5 for pgsql-bugs@arkaria.postgresql.org; Thu, 25 May 2023 19:10:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q2GLf-0004LL-GQ for pgsql-bugs@arkaria.postgresql.org; Thu, 25 May 2023 19:10:07 +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 1q2C8N-00051p-G0 for pgsql-bugs@lists.postgresql.org; Thu, 25 May 2023 14:40:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q2C8L-001pq3-1f for pgsql-bugs@lists.postgresql.org; Thu, 25 May 2023 14:40:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=24zuagkmpCCLpzA2BZLqtCKqog7TrtRP2mkXGWmJ/dc=; b=aq9iHW/YqBynqFINyNk+CTWEx8 1h2a3DCtfkmQpZnnIZ+Q+iUjZgwQmEORWbx1D8vvAd2z6bXT1WPxAmMaaRzQQseDA3KHhKz30npXL l0/x444wxDgH7OyIUT32G97j3na1PfoUgvoAmTsB5GkGsaYCCdjg4toPeKpUHfDeg8HHsz7kvsUZO y/UpUW7tHE6tvm3E4hQ1ssIev6SESNgPFcFkqsnX0a3HK7I1pq2kUF+GGWm2X8gDXaPpD4ASqpn1y NldsyfIH6/9Yzllyn68nBiiJnd1myB9t4a8vjY+/9XW3M+WYwWDon8zrFD3qMpw8GxFheISwQCRp4 wkiBmAdQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q2C8J-0000Rm-RV for pgsql-bugs@lists.postgresql.org; Thu, 25 May 2023 14:40:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1q2C8H-005epb-W3 for pgsql-bugs@lists.postgresql.org; Thu, 25 May 2023 14:40:01 +0000 Content-Type: multipart/mixed; boundary="===============0948406887863288008==" MIME-Version: 1.0 Subject: BUG #17945: Different order of definition of a constraint causes constraint violation To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: yannsalaun1@gmail.com Reply-To: yannsalaun1@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 25 May 2023 14:39:13 +0000 Message-ID: <17945-e6eb09170cd63524@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0948406887863288008== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzk0NQpMb2dnZWQgYnk6ICAgICAgICAgIFlhbm4gU2FsYcO8bgpFbWFp bCBhZGRyZXNzOiAgICAgIHlhbm5zYWxhdW4xQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE1LjMKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKVGhp cyBpcyBhIGJ1ZyByZXBvcnQgd2l0aCBhIHJlcHJvZHVjaWJsZSBjYXNlIHdoZXJlIGRpZmZlcmVu dCBvcmRlcnMgb2YKZGVmaW5pdGlvbiBvZiBhIFNRTCBjb25zdHJhaW50IGNhdXNlcyBkaWZmZXJl bnQgYmVoYXZpb3IuDQoNClRvIGJlIG1vcmUgc3BlY2lmaWMsIGlmIHRoZSBjb25zdHJhaW50IGlz IGRlZmluZWQgaW5zaWRlIHRoZSB0YWJsZQpkZWZpbml0aW9uIGFzIGluDQpgYGBzcWwNCkNSRUFU RSBUQUJMRSBub2RlICgNCiAgICBpZCBpbnRlZ2VyIFBSSU1BUlkgS0VZLA0KICAgIHBhcmVudF9p ZCBpbnRlZ2VyIFJFRkVSRU5DRVMgbm9kZShpZCkgT04gREVMRVRFIENBU0NBREUNCik7DQpgYGAN CnRoZSBiZWhhdmlvciBpcyBub3QgdGhlIHNhbWUgYXMgd2hlbiB0aGUgY29uc3RyYWludCBpcyBk ZWZpbmVkIGFmdGVyIGFsbAp0YWJsZXMgYXJlIGRlZmluZWQgKGxpa2UgaW4gdGhlIG91dHB1dCBv ZiBwZ19kdW1wKSBhcyBpbg0KYGBgc3FsDQpDUkVBVEUgVEFCTEUgbm9kZSAoDQogICAgaWQgaW50 ZWdlciBQUklNQVJZIEtFWSwNCiAgICBwYXJlbnRfaWQgaW50ZWdlcg0KKTsNCi0tIGRlZmluZSBh bGwgb3RoZXIgdGFibGVzLi4uDQpBTFRFUiBUQUJMRSBub2RlDQogICAgQUREIENPTlNUUkFJTlQg bm9kZXNfcGFyZW50X2lkX2ZrZXkgRk9SRUlHTiBLRVkgKHBhcmVudF9pZCkgUkVGRVJFTkNFUwpu b2RlKGlkKSBPTiBERUxFVEUgQ0FTQ0FERTsNCmBgYA0KDQpUaGUgcmVwcm9kdWN0aWJsZSBjYXNl IGNvbWVzIGZyb20gYW4gYXBwbGljYXRpb24gd2l0aCB0YWJsZXMgbW9kZWxsaW5nCmZpbGVzeXN0 ZW0gdHJlZXMuIFdoZW4gYSBwYXJlbnQgbm9kZSBpcyBkZWxldGVkLCBjaGlsZHJlbiBhcmUgZGVs ZXRlZCBpbgpjYXNjYWRlIHZpYSBmb3JlaWduIGtleSBjb25zdHJhaW50cy4NCg0KSGVyZSBpcyB0 aGUgZnVsbCBwc3FsIHNjcmlwdCB0byByZXByb2R1Y2UgdGhlIHByb2JsZW06DQpgYGBzcWwNCi0t IFNjaGVtYSBkZWZpbml0aW9uDQpDUkVBVEUgVEFCTEUgbm9kZSAoDQogICAgaWQgaW50ZWdlciBQ UklNQVJZIEtFWSwNCiAgICBwYXJlbnRfaWQgaW50ZWdlcg0KKTsNCkNSRUFURSBUQUJMRSBkaXIg KA0KICAgIGlkIGludGVnZXIgUFJJTUFSWSBLRVkgUkVGRVJFTkNFUyBub2RlKGlkKSBPTiBERUxF VEUgQ0FTQ0FERQ0KKTsNCkNSRUFURSBUQUJMRSBmaWxlICgNCiAgICBpZCBpbnRlZ2VyIFBSSU1B UlkgS0VZIFJFRkVSRU5DRVMgbm9kZShpZCkgT04gREVMRVRFIENBU0NBREUNCik7DQpDUkVBVEUg VEFCTEUgdCAoDQogICAgbWFpbl9kaXJfaWQgaW50ZWdlciBSRUZFUkVOQ0VTIGRpcihpZCkgT04g REVMRVRFIFNFVCBOVUxMLA0KICAgIG1haW5fZmlsZV9pZCBpbnRlZ2VyIFJFRkVSRU5DRVMgZmls ZShpZCkgT04gREVMRVRFIFNFVCBOVUxMLA0KICAgIG90aGVyX2ZpbGVfaWQgaW50ZWdlciBSRUZF UkVOQ0VTIGZpbGUoaWQpIE9OIERFTEVURSBTRVQgTlVMTA0KKTsNCg0KLS0gQ29uc3RyYWludCBk ZWZpbml0aW9uLiBJZiB3ZSBpbmxpbmUgdGhpcyBjb25zdHJhaW50IGluIHRoZSB0YWJsZQpkZWZp bml0aW9uLCB0aGUgU1FMIGVycm9yIGJlbG93IGRpc2FwcGVhcnMuDQpBTFRFUiBUQUJMRSBub2Rl DQogICAgQUREIENPTlNUUkFJTlQgbm9kZXNfcGFyZW50X2lkX2ZrZXkgRk9SRUlHTiBLRVkgKHBh cmVudF9pZCkgUkVGRVJFTkNFUwpub2RlKGlkKSBPTiBERUxFVEUgQ0FTQ0FERTsNCg0KLS0gRGF0 YSBpbnNlcnRpb24NCi0tIG1haW5fZGlyDQpJTlNFUlQgSU5UTyBub2RlIChpZCkgVkFMVUVTICgx KTsNCklOU0VSVCBJTlRPIGRpciAoaWQpIFZBTFVFUyAoMSk7DQoNCi0tIG1haW5fZmlsZSBpbiBt YWluX2Rpcg0KSU5TRVJUIElOVE8gbm9kZSAoaWQsIHBhcmVudF9pZCkgVkFMVUVTICgyLCAxKTsN CklOU0VSVCBJTlRPIGZpbGUgKGlkKSBWQUxVRVMgKDIpOw0KDQotLSBvdGhlcl9maWxlDQpJTlNF UlQgSU5UTyBub2RlIChpZCkgVkFMVUVTICgzKTsNCklOU0VSVCBJTlRPIGZpbGUgKGlkKSBWQUxV RVMgKDMpOw0KDQpJTlNFUlQgSU5UTyB0IChtYWluX2Rpcl9pZCwgbWFpbl9maWxlX2lkLCBvdGhl cl9maWxlX2lkKSBWQUxVRVMgKDEsIDIsIDMpOw0KDQotLSBEYXRhIGRlbGV0aW9uIGluIGEgdHJh bnNhY3Rpb24uDQpCRUdJTjsNCg0KLS0gRmlyc3QsIGRlbGV0ZSBvdGhlcl9maWxlICh0aGlzIHNl dHMgdC5vdGhlcl9maWxlX2lkIHRvIE5VTEwgdmlhIE9OIERFTEVURQpTRVQgTlVMTCkNCkRFTEVU RSBGUk9NIG5vZGUgV0hFUkUgaWQgPSAzOw0KDQotLSBUaGVuIGRlbGV0ZSBtYWluX2RpciAodGhp cyBzZXRzIHQubWFpbl9kaXJfaWQgYW5kIHQubWFpbl9maWxlX2lkIHRvIE5VTEwKdmlhIE9OIERF TEVURSBTRVQgTlVMTCkNCkRFTEVURSBGUk9NIG5vZGUgV0hFUkUgaWQgPSAxOw0KDQotLSBUaGUg c2Vjb25kIERFTEVURSBzdGF0ZW1lbnQgcmV0dXJucyB0aGUgZm9sbG93aW5nIGVycm9yLg0KDQot LSBFUlJPUjogIDIzNTAzOiBpbnNlcnQgb3IgdXBkYXRlIG9uIHRhYmxlICJ0IiB2aW9sYXRlcyBm b3JlaWduIGtleQpjb25zdHJhaW50ICJ0X21haW5fZmlsZV9pZF9ma2V5Ig0KLS0gREVUQUlMOiAg S2V5IChtYWluX2ZpbGVfaWQpPSgyKSBpcyBub3QgcHJlc2VudCBpbiB0YWJsZSAiZmlsZSIuDQot LSBTQ0hFTUEgTkFNRTogIHB1YmxpYw0KLS0gVEFCTEUgTkFNRTogIHQNCi0tIENPTlNUUkFJTlQg TkFNRTogIHRfbWFpbl9maWxlX2lkX2ZrZXkNCi0tIExPQ0FUSU9OOiAgcmlfUmVwb3J0VmlvbGF0 aW9uLCByaV90cmlnZ2Vycy5jOjI1MjgNCg0KUk9MTEJBQ0s7DQpgYGANCg0KSSBiZWxpZXZlIHRo aXMgcHNxbCBzY3JpcHQgaXMgc3VmZmljaWVudCB0byByZXByb2R1Y2UgdGhlIGJ1Zy4gTGV0IG1l IGtub3cKaWYgdGhhdCdzIG5vdCB0aGUgY2FzZSwgSSB3b3VsZCBiZSBoYXBweSB0byBwcm92aWRl IG1vcmUgZGV0YWlscy4NCg0KVGhhbmtzIGZvciB5b3VyIGFuc3dlci4NCg0KWWFubgoK --===============0948406887863288008==--