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 1qYNB4-001WLW-0c for pgsql-bugs@arkaria.postgresql.org; Tue, 22 Aug 2023 08:55:54 +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 1qYNB2-00GsVm-4b for pgsql-bugs@arkaria.postgresql.org; Tue, 22 Aug 2023 08:55:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qYN1f-00GoYv-4s for pgsql-bugs@lists.postgresql.org; Tue, 22 Aug 2023 08:46:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qYN1a-000L0h-8M for pgsql-bugs@lists.postgresql.org; Tue, 22 Aug 2023 08:46:10 +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=wdVUQSO6KNjkEFpspKusRQbuwy2NaI1Cf1yeRShBBig=; b=NdbAq07bnBSQxB3TFbh4Ko3YmU 7cNSmQWJiOxSA/NWrU2MDYwv6xzXo4xF7ns7v2Yq8C3p40TpHrJUKWHA3U9x7IbqWc/QfPyk4qyj5 MRAZRpcFqSSFwTqh2efSNqvm8QtVd2N3Mr156rUkzPOSgb03ZSjuIWYe55b8McatdupxnnahrZx6h 13dyePuZNoIr9pTRcBtag1dHxrq79HVpKtj81GJbuNkxq4uP/dOyikl7+j4cVoNRkmbVnUjD8MPrq sdbBRNYcr53Bnjefz2yA65Gbis1kBm3HqQQ08fIfx1qzxR9FOu++/NejNnlk99q0lLdgudtZAaMlC tt9b03nQ==; 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 1qYN1Y-00060N-79 for pgsql-bugs@lists.postgresql.org; Tue, 22 Aug 2023 08:46:04 +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 1qYN1W-000wKH-A8 for pgsql-bugs@lists.postgresql.org; Tue, 22 Aug 2023 08:46:02 +0000 Content-Type: multipart/mixed; boundary="===============3262270400824125997==" MIME-Version: 1.0 Subject: BUG #18064: Order of cascading deletes by foreign key; "on delete restrict" To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: portnov@bk.ru Reply-To: portnov@bk.ru, pgsql-bugs@lists.postgresql.org Date: Tue, 22 Aug 2023 08:45:04 +0000 Message-ID: <18064-41dae27eda0024e1@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 --===============3262270400824125997== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODA2NApMb2dnZWQgYnk6ICAgICAgICAgIElseWEgVi4gUG9ydG5vdgpF bWFpbCBhZGRyZXNzOiAgICAgIHBvcnRub3ZAYmsucnUKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNS40 Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpI ZWxsby4NCg0KSSBzdHVtYmxlZCB1cG9uIGFuIGludGVyZXN0aW5nIHNpdHVhdGlvbiB3aGljaCBh cHBlYXJzIHdoZW4gdGhlcmUgaXMgYQpudW1iZXIgb2YgdGFibGVzIGNvbm5lY3RlZCB3aXRoIGZv cmVpZ24ga2V5cywgc29tZSBvZiB3aGljaCBhcmUgIm9uIGRlbGV0ZQpjYXNjYWRlIiBhbmQgb3Ro ZXJzIGFyZSAib24gZGVsZXRlIHJlc3RyaWN0IiBvciAib24gZGVsZXRlIG5vIGFjdGlvbiIuIFRo ZQpnZW5lcmFsIHJlcXVpcmVtZW50IGlzIHRoYXQgd2UgaGF2ZSBvbmUgdGFibGUgd2hpY2ggaXMg Im1haW4iLCBhbmQgcmVsYXRlZApyZWNvcmRzIGZyb20gb3RoZXIgKGRldGFpbCkgdGFibGVzIG11 c3QgYmUgZGVsZXRlZCBhdXRvbWF0aWNhbGx5IHdoZW4gb25lCmRlbGV0ZXMgYSByZWNvcmQgZnJv bSB0aGUgIm1haW4iIHRhYmxlLiBCdXQgc2hvdWxkIGJlIG5vdCBwb3NzaWJsZSB0byBkZWxldGUK ZnJvbSBzb21lIG9mIGRldGFpbCB0YWJsZXMgYmVmb3JlIGRlbGV0aW5nIGNvcnJlc3BvbmRpbmcg cmVjb3JkcyBmcm9tIG90aGVyCmRldGFpbCB0YWJsZXMuDQpJIGRpc2N1c3NlZCBpdCBpbiBsb2Nh bCB0ZWxlZ3JhbSBQU1FMIGNvbW11bml0eSwgYW5kIFlhcm9zbGF2IFNjaGVraW4KYWR2aXNlZCBt ZSB0byBicmluZyB0aGlzIG1hdHRlciB0byAtYnVncyBmb3IgZGlzY3Vzc2lvbi4NCg0KU3RlcHMg dG8gcmVwcm9kdWNlOg0KDQotLSBtYWluIHRhYmxlDQpjcmVhdGUgdGFibGUgdHN0X3QxICgNCglp ZCBpbnQgbm90IG51bGwgcHJpbWFyeSBrZXksDQoJbmFtZSB0ZXh0DQopOw0KDQotLSBvdGhlciBh cmUgZGV0YWlsIHRhYmxlcw0KY3JlYXRlIHRhYmxlIHRzdF9hICgNCglpZCBpbnQgbm90IG51bGwg cHJpbWFyeSBrZXksDQoJdDFpZCBpbnQgcmVmZXJlbmNlcyB0c3RfdDEgb24gZGVsZXRlIGNhc2Nh ZGUsDQoJbmFtZSB0ZXh0DQopOw0KDQpjcmVhdGUgdGFibGUgdHN0X2IgKA0KCWlkIGludCBub3Qg bnVsbCBwcmltYXJ5IGtleSwNCglhaWQgaW50IHJlZmVyZW5jZXMgdHN0X2Egb24gZGVsZXRlIGNh c2NhZGUsDQoJbmFtZSB0ZXh0DQopOw0KDQpjcmVhdGUgdGFibGUgdHN0X2QgKA0KCWlkIGludCBu b3QgbnVsbCBwcmltYXJ5IGtleSwNCgl0MWlkIGludCByZWZlcmVuY2VzIHRzdF90MSBvbiBkZWxl dGUgY2FzY2FkZSwNCgluYW1lIHRleHQNCik7DQoNCmNyZWF0ZSB0YWJsZSB0c3RfYyAoDQoJaWQg aW50IG5vdCBudWxsIHByaW1hcnkga2V5LA0KCWJpZCBpbnQgcmVmZXJlbmNlcyB0c3RfYiBvbiBk ZWxldGUgY2FzY2FkZSwNCglkaWQgaW50IHJlZmVyZW5jZXMgdHN0X2Qgb24gZGVsZXRlIHJlc3Ry aWN0LCAtLSBvcjogb24gZGVsZXRlIG5vIGFjdGlvbg0KCW5hbWUgdGV4dA0KKTsNCg0KaW5zZXJ0 IGludG8gdHN0X3QxIChpZCwgbmFtZSkgdmFsdWVzICgxLCAnVDEnKTsNCmluc2VydCBpbnRvIHRz dF9hIChpZCwgdDFpZCwgbmFtZSkgdmFsdWVzICgxLCAxLCAnQScpOw0KaW5zZXJ0IGludG8gdHN0 X2IgKGlkLCBhaWQsIG5hbWUpIHZhbHVlcyAoMSwgMSwgJ0InKTsNCmluc2VydCBpbnRvIHRzdF9k IChpZCwgdDFpZCwgbmFtZSkgdmFsdWVzICgxLCAxLCAnRCcpOw0KaW5zZXJ0IGludG8gdHN0X2Mg KGlkLCBiaWQsIGRpZCwgbmFtZSkgdmFsdWVzICgxLCAxLCAxLCAnQycpOw0KDQotLSBkZWxldGUg ZnJvbSB0aGUgbWFzdGVyIHRhYmxlDQpkZWxldGUgZnJvbSB0c3RfdDEgd2hlcmUgaWQgPSAxOw0K DQpJIGFsc28gdHJpZWQgd2l0aCAib24gZGVsZXRlIG5vIGFjdGlvbiIgaW5zdGVhZCBvZiAib24g ZGVsZXRlIHJlc3RyaWN0IiwgYnV0CnRoZSByZXN1bHQgZGlkIG5vdCBjaGFuZ2UuDQoNCkV4cGVj dGVkIGJlaGF2aW9yOg0KDQp0aGUgbGFzdCBkZWxldGUgc3RhdGVtZW50IHdvcmtzIGZpbmU6IGFs bCByZWNvcmRzIHdlIGluc2VydGVkIGFyZSBkZWxldGVkLAphbmQgbm8gZXJyb3IgaXMgdGhyb3du Lg0KRm9yIGV4YW1wbGUsIGluIE9yYWNsZSB0aGUgc2FtZSBzY2VuYXJpbyB3b3JrcyB3aXRob3V0 IGVycm9yLg0KDQpBY3R1YWwgYmVoYXZpb3I6DQoNCnwtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLXwNCnwgZGVsZXRlIGZyb20gdHN0X3QxIHdoZXJl IGlkID0gMSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwNCnwtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLXwNCnwgRVJST1I6ICB1cGRhdGUgb3IgZGVsZXRl IG9uIHRhYmxlICJ0c3RfZCIgdmlvbGF0ZXMgZm9yZWlnbiBrZXkgY29uc3RyYWludAoidHN0X2Nf ZGlkX2ZrZXkiIG9uIHRhYmxlICJ0c3RfYyIgIHwNCnwgREVUQUlMOiAgS2V5IChpZCk9KDEpIGlz IHN0aWxsIHJlZmVyZW5jZWQgZnJvbSB0YWJsZSAidHN0X2MiLiAgICAgICAgICAgICAKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwNCg0KTXkgaW50ZXJwcmV0YXRpb24gb2YgdGhl IHByb2JsZW06DQoNCkl0IGFwcGVhcnMgdGhhdCBQb3N0Z3JlU1FMIGlzIG5vdCBhYmxlIHRvIGZp Z3VyZSBvdXQsIGluIHdoaWNoIG9yZGVyIHNob3VsZAppdCBkZWxldGUgcmVjb3JkcyBmcm9tIGRl dGFpbCB0YWJsZXMgaW4gb3JkZXIgdG8gbm90IGJlIHJlc3RyaWN0ZWQgd2l0aCAib24KZGVsZXRl IHJlc3RyaWN0IC8gbm8gYWN0aW9uIiBjb25zdHJhaW50cy4gUHJvYmFibHkgUEcgc2hvdWxkIGRv IHRvcG9sb2dpY2FsCnNvcnRpbmcgaW4gb3JkZXIgdG8gdW5kZXJzdGFuZCB0aGUgY29ycmVjdCBv cmRlciBvZiBkZWxldGVzLg0KDQpBbm90aGVyIGludGVycHJldGF0aW9uIG9mIHByb2JsZW06IFBH IGRvZXMgbm90IHNlZSB0aGUgZGlmZmVyZW5jZSBiZXR3ZWVuCiJyZXN0cmljdCIgYW5kICJubyBh Y3Rpb24iOyBhcyBmYXIgYXMgSSB1bmRlcnN0b29kLCAicmVzdHJpY3QiIHZhcmlhbnQKc2hvdWxk IGRvIGl0J3MgY29uc2lzdGVuY3kgY2hlY2sgb25seSBhZnRlciBhbGwgcm93cyB3aGljaCBhcmUg dG8gYmUgZGVsZXRlZApieSBvbmUgU1FMIHN0YXRlbWVudCBhcmUgZGVsZXRlZDsgYnV0IGFjdHVh bGx5IHRoZSBjaGVjayBpcyB0cmlnZ2VyZWQgcmlnaHQKYWZ0ZXIgImRlbGV0ZSBmcm9tIHRzdF9k Iiwgd2l0aG91dCB3YWl0aW5nIGZvciB3aGVuIHRoZSByZWNvcmQgZnJvbSB0c3RfYwp3aWxsIGJl IGRlbGV0ZWQgYnkgdGhlIHNhbWUgU1FMIHN0YXRlbWVudC4NCg0KVGhlcmUgaXMgbW9yZSBvciBs ZXNzIG9idmlvdXMgd29ya2Fyb3VuZCBmb3IgdGhpcyBwcm9ibGVtIChkZWxldGUgZnJvbQpkZXRh aWwgcmVjb3JkcyBpbiB0aGUgY29ycmVjdCBvcmRlciBlaXRoZXIgbWFudWFsbHkgb3IgYnkgd3Jp dGluZyBhIGNvcnJlY3QKc2VxdWVuY2Ugb2YgZXhwbGljaXQgdHJpZ2dlcnMpLCBidXQgaW4gYXBw bGljYXRpb25zIHdpdGggY29tcGxleCBzY2hlbWFzCnN1Y2ggd29ya2Fyb3VuZCB3aWxsIHRha2Ug YSBudW1iZXIgb2YgbWFuLWhvdXJzLiBTbyBJIHRoaW5rIFBHJ3MgYmVoYXZpb3IKc2hvdWxkIGJl IGNoYW5nZWQuDQoNCkJlc3QgcmVnYXJkcywNCklseWEgUG9ydG5vdi4KCg== --===============3262270400824125997==--