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 1qrLH2-003mYR-IN for pgsql-bugs@arkaria.postgresql.org; Fri, 13 Oct 2023 16:44:28 +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 1qrLH0-002M1s-8e for pgsql-bugs@arkaria.postgresql.org; Fri, 13 Oct 2023 16:44:26 +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 1qrJ89-001Gdo-GB for pgsql-bugs@lists.postgresql.org; Fri, 13 Oct 2023 14:27:10 +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 1qrJ85-000IyE-3K for pgsql-bugs@lists.postgresql.org; Fri, 13 Oct 2023 14:27:08 +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=BUSM80qFK8ctwIfPyj0RNR2T/ge2KEePyzqjBS1+4s8=; b=hSxhwI7gq9F6xQE99m4mZ3kJxg /qGTwKL66VeySvR+fPbZAsBpYHPSSEF+IxEMhmalsL1lYmhD8RRwTzRYqJrNOxkr5q9LPHg6hQtOQ 1uVw8xqfvmhO+pzSxbVKUxLBMcTvGXzi6H2mjHuZjZngwSXmR2LQ2+lE1/b6bNso84E3klYypupO4 aZNNWby2FK1oVD9XKPGhCFY2SzGYqD8UXyOmuogG9ENxjuXTMVnLJNR8WRmd5Oxxlzhy1J0ch5ElX +Qd8PTnYeZ0WJrdL8AcR83ChAuMtsNvLTeQr5NSyILHTDi51Xey1lYvNrbORVWsqqGr/HF92E+VdC /Wzo2E8Q==; 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 1qrJ84-0004b2-I0 for pgsql-bugs@lists.postgresql.org; Fri, 13 Oct 2023 14:27: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 1qrJ80-001KdD-UY for pgsql-bugs@lists.postgresql.org; Fri, 13 Oct 2023 14:27:02 +0000 Content-Type: multipart/mixed; boundary="===============1397865871518807985==" MIME-Version: 1.0 Subject: BUG #18156: Self-referential foreign key in partitioned table not enforced on deletes To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: fastcat@gmail.com Reply-To: fastcat@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 13 Oct 2023 14:26:56 +0000 Message-ID: <18156-a44bc7096f0683e6@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 --===============1397865871518807985== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE1NgpMb2dnZWQgYnk6ICAgICAgICAgIE1hdHRoZXcgR2FiZWxlci1M ZWUKRW1haWwgYWRkcmVzczogICAgICBmYXN0Y2F0QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE2LjAKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoK V2hlbiBhIHBhcnRpdGlvbmVkIHRhYmxlIGhhcyBhIHNlbGYtcmVmZXJlbnRpYWwgZm9yZWlnbiBr ZXksIEknbSBmaW5kaW5nCnRoYXQgdGhlIGtleSBpcyBub3QgZW5mb3JjZWQgZHVyaW5nIGRlbGV0 ZXMgZnJvbSB0aGUgdGFibGUuDQoNCkEgc2ltcGxlIHJlcHJvIHNjcmlwdDoNCg0KY3JlYXRlIHRh YmxlIHggKA0KICAgIHAgaW50NCBub3QgbnVsbCwNCiAgICBpIGludDQgbm90IG51bGwsDQogICAg ZiBpbnQ0IG51bGwsDQogICAgcHJpbWFyeSBrZXkgKHAsIGkpLA0KICAgIGZvcmVpZ24ga2V5IChw LCBmKSByZWZlcmVuY2VzIHggKHAsIGkpDQopDQpwYXJ0aXRpb24gYnkgbGlzdCAocCk7DQpjcmVh dGUgdGFibGUgeDEgcGFydGl0aW9uIG9mIHggZm9yIHZhbHVlcyBpbiAoMCk7DQoNCmluc2VydCBp bnRvIHggdmFsdWVzICgwLDEsbnVsbCksICgwLDIsMSk7DQpkZWxldGUgZnJvbSB4IHdoZXJlIChw LGkpID0gKDAsMSk7DQpzZWxlY3QgKiBmcm9tIHg7DQoNClRoZSBmaW5hbCBzZWxlY3Qgc2hvd3Mg dGhlIG9uZSByb3cgd2l0aCB0aGUgY2xlYXJseSB2aW9sYXRlZCBmb3JlaWduIGtleQp2YWx1ZXM6 DQogcCB8IGkgfCBmIA0KLS0tKy0tLSstLS0NCiAwIHwgMiB8IDENCigxIHJvdykNCg0KSSd2ZSBy ZXByb2R1Y2VkIHRoaXMgd2l0aCAxNS40IGFuZCAxNi4wIHVzaW5nIHRoZSBvZmZpY2lhbCBkb2Nr ZXIgaW1hZ2VzLApzcGVjaWZpY2FsbHkgYHBvc3RncmVzLzE1LWFscGluZWAgYW5kIGBwb3N0Z3Jl cy8xNi1hbHBpbmVgLiBJIGhhdmVuJ3QgdGVzdGVkCm9sZGVyIHZlcnNpb25zIGFzIG15IGFwcGxp Y2F0aW9uIHJlcXVpcmVzIGZlYXR1cmVzIG5ldyB0byAxNS54LiBJJ3ZlIHRyaWVkCndpdGggYm90 aCBsaXN0IGFuZCBoYXNoIHBhcnRpdGlvbmluZywgYW5kIGl0IHJlcHJvZHVjZXMgd2l0aCBib3Ro LiBJIGNhbgpvbmx5IHJlcHJvZHVjZSBpdCB3aXRoIHNlbGYtcmVmZXJlbnRpYWwgZm9yZWlnbiBr ZXlzIGFuZCBvbmx5IHdpdGgKcGFydGl0aW9uZWQgdGFibGVzLg0KDQpJIGRpc2NvdmVyZWQgdGhp cyB3aXRoIGEgc2xpZ2h0bHkgbW9yZSBjb21wbGV4IHNpdHVhdGlvbiBpbnZvbHZpbmcgYW4gYG9u CmRlbGV0ZSBzZXQgbnVsbGAgY2xhdXNlIGluIHRoZSBGSywgYnV0IGFzIHNlZW4gYWJvdmUgdGhh dCBpcyBub3QgcmVxdWlyZWQgdG8KcmVwcm9kdWNlIHRoZSBpc3N1ZS4KCg== --===============1397865871518807985==--