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 1maJG5-0005jf-JB for pgsql-bugs@arkaria.postgresql.org; Tue, 12 Oct 2021 15:00:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maJG3-0005pd-Fz for pgsql-bugs@arkaria.postgresql.org; Tue, 12 Oct 2021 14:59:59 +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 1maIJ9-00020I-NA for pgsql-bugs@lists.postgresql.org; Tue, 12 Oct 2021 13:59:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maIJ7-0003I3-0a for pgsql-bugs@lists.postgresql.org; Tue, 12 Oct 2021 13:59:07 +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=Y/u/TYECQpAsmjp9e0rZIajel9BQ7+K75MUxiWQrE1s=; b=BGighjjI4URBy3ZdibwZmoINgJ IxC2thPJAGPH4dg6VOjvCMxsE7DY4x6TYeEMO0e9inb0ZFoi+7iJU42ypnZcmb2PN00AMapKuHq8v LxwzTMu0TrUsQYq47txMe7FQhhl2qMVmKNztF3NdHTHeDO7rmKSiglwQr54WWpAlgWtBLmzvaAG/w F4Xxro2gTCPvmm5Rt13/I0Ax7pMhqiaeqGn2Hz5h1P1EaDjOCYhp+A0T+p5QwwqlVjpY9ihj36XJr jwp/CfeCFs1vTXm4+xU3GxNtf33jdm4VMd5vyCUz4PNYvyVTz1jk4rZ8R8TEnSi/gULMNn9NMJojK 9b7dXacQ==; 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 1maIJ5-0005ac-Q2 for pgsql-bugs@lists.postgresql.org; Tue, 12 Oct 2021 13:59:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maIJ4-0005xo-6n for pgsql-bugs@lists.postgresql.org; Tue, 12 Oct 2021 13:59:02 +0000 Content-Type: multipart/mixed; boundary="===============0471466245436364384==" MIME-Version: 1.0 Subject: BUG #17223: Foreign key SET NULL depends on constraints order To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: denisvermylen@gmail.com Reply-To: denisvermylen@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 12 Oct 2021 13:58:41 +0000 Message-ID: <17223-2c62a8409b46f961@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 --===============0471466245436364384== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzIyMwpMb2dnZWQgYnk6ICAgICAgICAgIERlbmlzIFZlcm15bGVuCkVt YWlsIGFkZHJlc3M6ICAgICAgZGVuaXN2ZXJteWxlbkBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMi44Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIwLjA0CkRlc2NyaXB0aW9uOiAg ICAgICAgCgpIZWxsbywNCg0KSSd2ZSBlbmNvdW50ZXJlZCBhbiBpbnRlcmVzdGluZyBpc3N1ZSB3 aGVyZSBpdCB0dXJuZWQgb3V0IHRoZSBvcmRlciBvZgpmb3JlaWduIGtleSBjb25zdHJhaW50cyBj cmVhdGlvbiBtYXR0ZXJlZCBpbiBhbGxvd2luZyBhIGNlcnRhaW4gdHJhbnNhY3Rpb24Kb3Igbm90 Lg0KDQpUaGUgc2ltcGxpZmllZCB0ZXN0IGNhc2U6DQoNCmBgYA0Kcm9vdEBtZTp+IyBjcmVhdGVk YiB0ZXN0DQpyb290QG1lOn4jIHBzcWwgdGVzdCAtLXF1aWV0IC1jICINCkNSRUFURSBUQUJMRSBi cmFuY2ggKA0KICAgIGlkIGludCBQUklNQVJZIEtFWQ0KKTsNCkNSRUFURSBUQUJMRSBjb21taXQg KA0KICAgIGlkIGludCBQUklNQVJZIEtFWSwNCiAgICBicmFuY2hfaWQgaW50LA0KICAgIENPTlNU UkFJTlQgY29tbWl0X2JyYW5jaF9mayBGT1JFSUdOIEtFWShicmFuY2hfaWQpIFJFRkVSRU5DRVMg YnJhbmNoKGlkKQpPTiBERUxFVEUgQ0FTQ0FERQ0KKTsNCkNSRUFURSBUQUJMRSBidWlsZCAoDQog ICAgaWQgaW50IFBSSU1BUlkgS0VZLA0KICAgIG5hbWUgdmFyY2hhcigxMDApLA0KICAgIGJyYW5j aF9pZCBpbnQsDQogICAgY29tbWl0X2lkIGludCwNCiAgICBDT05TVFJBSU5UIGJ1aWxkX2NvbW1p dF9mayBGT1JFSUdOIEtFWShjb21taXRfaWQpIFJFRkVSRU5DRVMgY29tbWl0KGlkKQpPTiBERUxF VEUgU0VUIE5VTEwsDQogICAgQ09OU1RSQUlOVCBidWlsZF9icmFuY2hfZmsgRk9SRUlHTiBLRVko YnJhbmNoX2lkKSBSRUZFUkVOQ0VTIGJyYW5jaChpZCkKT04gREVMRVRFIFNFVCBOVUxMDQopOw0K SU5TRVJUIElOVE8gYnJhbmNoIFZBTFVFUyAoMSk7DQpJTlNFUlQgSU5UTyBjb21taXQgVkFMVUVT ICgxLCAxKTsNCklOU0VSVCBJTlRPIGJ1aWxkIFZBTFVFUyAoMSwgJ29uZScsIDEsIDEpOyINCnJv b3RAbWU6fiMgcHNxbCB0ZXN0IC1jICJCRUdJTjtVUERBVEUgYnVpbGQgU0VUIG5hbWUgPSAnb25l JztERUxFVEUgRlJPTQpicmFuY2g7Uk9MTEJBQ0s7Ig0KYGBgDQoNClRoZSBsYXN0IHRyYW5zYWN0 aW9uIGhlcmUgd29ya3MgZmluZSBiZWNhdXNlIHRoZSBvcmRlciBvZiB0aGUgZm9yZWlnbiBrZXlz CndhcyBjb21wYXRpYmxlLiBTaG91bGQgd2UgaGF2ZSBhZGRlZCB0aGUgZm9yZWlnbiBrZXlzIGFm dGVyd2FyZHMgaW4gdGhlCnJldmVyc2Ugb3JkZXIsIG9yIGlmIHdlIGRyb3AgJiByZS1hZGQgdGhl IGBjb21taXRfYnJhbmNoX2ZrYCBjb25zdHJhaW50LApkb2luZyB0aGUgc2FtZSB0cmFuc2FjdGlv biBubyBsb25nZXIgd29ya3M6DQoNCmBgYA0Kcm9vdEBtZTp+IyBwc3FsIHRlc3QgLS1xdWlldCAt YyAiDQpBTFRFUiBUQUJMRSBjb21taXQgRFJPUCBDT05TVFJBSU5UIGNvbW1pdF9icmFuY2hfZms7 DQpBTFRFUiBUQUJMRSBjb21taXQgQUREIENPTlNUUkFJTlQgY29tbWl0X2JyYW5jaF9mayBGT1JF SUdOIEtFWSAoYnJhbmNoX2lkKQpSRUZFUkVOQ0VTIGJyYW5jaChpZCkgT04gREVMRVRFIENBU0NB REU7Ig0Kcm9vdEBtZTp+IyBwc3FsIHRlc3QgLWMgIkJFR0lOO1VQREFURSBidWlsZCBTRVQgbmFt ZSA9ICdvbmUnO0RFTEVURSBGUk9NCmJyYW5jaDtST0xMQkFDSzsiDQpFUlJPUjogIGluc2VydCBv ciB1cGRhdGUgb24gdGFibGUgImJ1aWxkIiB2aW9sYXRlcyBmb3JlaWduIGtleSBjb25zdHJhaW50 CiJidWlsZF9jb21taXRfZmsiDQpERVRBSUw6ICBLZXkgKGNvbW1pdF9pZCk9KDEpIGlzIG5vdCBw cmVzZW50IGluIHRhYmxlICJjb21taXQiLg0KYGBgDQoNCkZyb20gYSB1c2VyJ3MgcGVyc3BlY3Rp dmUsIHRoZSBlcnJvciBkb2Vzbid0IG1ha2Ugc2Vuc2UuIFRoZSBrZXkgaXMgbm90CnByZXNlbnQs IGJ1dCBpdCdzIHN1cHBvc2VkIHRvIGJlIHNldCB0byBOVUxMIGFjY29yZGluZyB0byB0aGUgRksg Y29uc3RyYWludCwKd2h5IGRvZXMgaXQgcmFpc2UgYW4gZXJyb3I/IEkgYWxzbyBjb3VsZG4ndCBm aW5kIGFueSBkb2N1bWVudGF0aW9uIG9uIEZLCmNvbnN0cmFpbnRzIG9yZGVyIGJlaW5nIHJlbGV2 YW50IGluIHRoZSBkb2N1bWVudGF0aW9uLg0KDQpTaWRlLW5vdGU6IERvaW5nIGEgcGxhaW4tdGV4 dCBkdW1wIGNhbiBhbHNvIG1vZGlmeSB0aGUgb3JkZXIgb2YgdGhlCmNvbnN0cmFpbnRzIGFzIGl0 IHNlZW1zIHRvIG9yZGVyIHRoZW0gYWxwaGFiZXRpY2FsbHkuIFdpdGggdGhlc2UgY29uc3RyYWlu dApuYW1lcyBkdW1waW5nIHRoZSBEQiB3aXRob3V0IHRoZSBpc3N1ZSBhbmQgcmVzdG9yaW5nIGl0 IGludHJvZHVjZXMgdGhlCnByb2JsZW0uDQoNCmBgYA0Kcm9vdEBtZTp+IyBjcmVhdGVkYiB0ZXN0 MiAmJiBwZ19kdW1wIHRlc3QgfCBwc3FsIHRlc3QyIC0tcXVpZXQNCnJvb3RAbWU6fiMgcHNxbCB0 ZXN0MiAtYyAiQkVHSU47VVBEQVRFIGJ1aWxkIFNFVCBuYW1lID0gJ29uZScgV0hFUkUgaWQgPQox O0RFTEVURSBGUk9NIGJyYW5jaCBXSEVSRSBpZCA9IDE7Uk9MTEJBQ0s7Ig0KRVJST1I6ICBpbnNl cnQgb3IgdXBkYXRlIG9uIHRhYmxlICJidWlsZCIgdmlvbGF0ZXMgZm9yZWlnbiBrZXkgY29uc3Ry YWludAoiYnVpbGRfY29tbWl0X2ZrIg0KREVUQUlMOiAgS2V5IChjb21taXRfaWQpPSgxKSBpcyBu b3QgcHJlc2VudCBpbiB0YWJsZSAiY29tbWl0Ii4NCmBgYA0KDQpUaGFua3MgZm9yIHJlYWRpbmcs DQpEZW5pcwoK --===============0471466245436364384==--