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 1sKDuZ-008vsC-Ku for pgsql-bugs@arkaria.postgresql.org; Thu, 20 Jun 2024 09:16:55 +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 1sKDuX-0030NI-DV for pgsql-bugs@arkaria.postgresql.org; Thu, 20 Jun 2024 09:16:54 +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 1sKDp0-002sjk-Fk for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 09:11:11 +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 1sKDow-002cJu-Pb for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 09:11: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=1XPnOYrsOeA4tuJMa6bKKUd254zQCCcCIDHg+2V5KyQ=; b=BvxIZLZQujT8HekAr8oZP5nCmC 0S1RAQ5Hp630IGhVMq6BU7SsNfLQy79LgCZf49VJnQahxiC6BT4mviNWbwb+F+CWrZ84JM6Sk5r/o O2bQQS5P1UBKwGZ1cpkPU4f+cK1kZ4v2Pqz6qujV6XtwmReR0da1xoyNfdMyrdsjSjHr4Vuo+XCwF q+viT0j3jaDSNOEKeJhhyCCLrh+sKrb1QWfbERZiyi+0KqF4lpf3zCPd5ickl/uELOh3nOvS1SY9F o9t2t1p8fZddgkYyTsL2DcetTguYxJwZrV754iWe5xfhOhyFkR9fogyB3dhty8giGz0fKQIcLz9ds VYjRJuCw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKDov-0072Mz-3e for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 09:11:05 +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 1sKDos-0009Qc-1J for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 09:11:02 +0000 Content-Type: multipart/mixed; boundary="===============6208961228568585904==" MIME-Version: 1.0 Subject: BUG #18516: Foreign key data integrity is not validated when reenabled the trigger on tables To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mujjamil995@gmail.com Reply-To: mujjamil995@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 20 Jun 2024 09:10:16 +0000 Message-ID: <18516-a7e2ae00e4ccf5ca@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 --===============6208961228568585904== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODUxNgpMb2dnZWQgYnk6ICAgICAgICAgIE11emFtbWlsIFEKRW1haWwg YWRkcmVzczogICAgICBtdWpqYW1pbDk5NUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx NS42Ck9wZXJhdGluZyBzeXN0ZW06ICAgcmVobDcKRGVzY3JpcHRpb246ICAgICAgICAKCkhpLA0K SSBjb21lIHVwIHdpdGggYSB3ZWlyZCBpc3N1ZSBpbiB0aGUgUG9zdGdyZVNRTCAxNS42IHZlcnNp b24uIFRvIHVwZGF0ZSB0aGUKZGF0YSBpbiB0aGUgdGFibGVzIEkgZ2VuZXJhbGx5IGRpc2FibGUg YWxsIHRyaWdnZXJzIG9uIHRoZSB0YWJsZSB1c2luZyB0aGUKc3VwZXJ1c2VyIHByaXZpbGVnZSBh bmQgZW5hYmxlIHRoZSBhZnRlciB0aGUgZGF0YSBjb3B5IHRvIGF2b2lkIHRoZSBjaGVja2luZwp0 aGUgcGFyZW50IGFuZCBjaGlsZCB0YWJsZXMgc2VxdWVuY2UuIER1cmluZyB0aGUgZW5hYmxlIHBy b2Nlc3MgRksKY29uc3RyYWludCBzaG91bGQgY2hlY2sgdGhlIGRhdGEgaW50ZWdyaXR5IGJldHdl ZW4gdGhlIGNoaWxkIGFuZCBwYXJlbnQKdGFibGVzLiBidXQgc29tZWhvdyB0aGlzIGlzIHNraXBw ZWQgYW5kIHRyaWdnZXIgZW5hYmxlZCB3aXRob3V0IGFueSBpc3N1ZQphbmQgbGF0ZXIgZHVyaW5n IHRoZSBkYXRhIHJlc3RvcmF0aW9uIHRoaXMgaXNzdWUgaXMgaWRlbnRpZmllZC4NCg0KUGxlYXNl IGNoZWNrIHRoZSBiZWxvdyBzdGVwcyBhbmQgc2hhcmUgeW91ciBmZWVkYmFjayBvbiB0aGlzLg0K DQpUbyByZWNyZWF0ZSB0aGUgaXNzdWUgeW91IGNhbiBmb2xsb3cgdGhlIGJlbG93IHN0ZXBzOiAt DQoNCmEpQ3JlYXRlIHBhcmVudCBhbmQgY2hpbGQgdGFibGVzDQp0ZXN0X2RiPSMgY3JlYXRlIHRh YmxlIGRhdGFiYXNlX2xvZ2luIChpZCBpbnQgZ2VuZXJhdGVkIGFsd2F5cyBhcwppZGVudGl0eSxk Ym5hbWUgdmFyY2hhciwgbG9naW4gdmFyY2hhcik7DQp0ZXN0X2RiPSMgY3JlYXRlIHRhYmxlIGRh dGFiYXNlICggaWQgaW50IGdlbmVyYXRlZCBhbHdheXMgYXMgaWRlbnRpdHksCnNlcnZlcl9uYW1l IHZhcmNoYXIsZGJuYW1lIHZhcmNoYXIgcHJpbWFyeSBrZXkpOw0KQ1JFQVRFIFRBQkxFDQoNCmIp QWRkIEZLIGNvbnN0cmFpbnQgDQp0ZXN0X2RiPSMgYWx0ZXIgdGFibGUgZGF0YWJhc2VfbG9naW4g YWRkIGNvbnN0cmFpbnQgZGJuYW1lX2ZrIEZPUkVJR04KS0VZKGRibmFtZSkgUkVGRVJFTkNFUyBk YXRhYmFzZShkYm5hbWUpOw0KQUxURVIgVEFCTEUNCnRlc3RfZGI9IyBcZCBkYXRhYmFzZV9sb2dp bg0KICAgICAgICAgICAgICAgICAgICAgICAgICBUYWJsZSAicHVibGljLmRhdGFiYXNlX2xvZ2lu Ig0KIENvbHVtbiB8ICAgICAgIFR5cGUgICAgICAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCAg ICAgICAgICAgRGVmYXVsdA0KLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0t LSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIGlkICAgICB8IGlu dGVnZXIgICAgICAgICAgIHwgICAgICAgICAgIHwgbm90IG51bGwgfCBnZW5lcmF0ZWQgYWx3YXlz IGFzCmlkZW50aXR5DQogZGJuYW1lIHwgY2hhcmFjdGVyIHZhcnlpbmcgfCAgICAgICAgICAgfCAg ICAgICAgICB8DQogbG9naW4gIHwgY2hhcmFjdGVyIHZhcnlpbmcgfCAgICAgICAgICAgfCAgICAg ICAgICB8DQpGb3JlaWduLWtleSBjb25zdHJhaW50czoNCiAgICAiZGJuYW1lX2ZrIiBGT1JFSUdO IEtFWSAoZGJuYW1lKSBSRUZFUkVOQ0VTIGRhdGFiYXNlKGRibmFtZSkNCg0KdGVzdF9kYj0jIFxk IGRhdGFiYXNlDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFRhYmxlICJwdWJsaWMu ZGF0YWJhc2UiDQogICBDb2x1bW4gICAgfCAgICAgICBUeXBlICAgICAgICB8IENvbGxhdGlvbiB8 IE51bGxhYmxlIHwgICAgICAgICAgCkRlZmF1bHQNCi0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0t LS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLQ0KIGlkICAgICAgICAgIHwgaW50ZWdlciAgICAgICAgICAgfCAgICAgICAgICAgfCBub3Qg bnVsbCB8IGdlbmVyYXRlZCBhbHdheXMKYXMgaWRlbnRpdHkNCiBzZXJ2ZXJfbmFtZSB8IGNoYXJh Y3RlciB2YXJ5aW5nIHwgICAgICAgICAgIHwgICAgICAgICAgfA0KIGRibmFtZSAgICAgIHwgY2hh cmFjdGVyIHZhcnlpbmcgfCAgICAgICAgICAgfCBub3QgbnVsbCB8DQpJbmRleGVzOg0KICAgICJk YXRhYmFzZV9wa2V5IiBQUklNQVJZIEtFWSwgYnRyZWUgKGRibmFtZSkNClJlZmVyZW5jZWQgYnk6 DQogICAgVEFCTEUgImRhdGFiYXNlX2xvZ2luIiBDT05TVFJBSU5UICJkYm5hbWVfZmsiIEZPUkVJ R04gS0VZIChkYm5hbWUpClJFRkVSRU5DRVMgZGF0YWJhc2UoZGJuYW1lKQ0KDQpjKUluc2VydCB0 aGUgdGVzdCBkYXRhIGludG8gdGhlIHRhYmxlcw0KDQp0ZXN0X2RiPSMgaW5zZXJ0IGludG8gZGF0 YWJhc2Uoc2VydmVyX25hbWUsZGJuYW1lKQp2YWx1ZXMoJ3Rlc3Rfc2VydmVyMScsJ3Rlc3RfZGJf MScpOw0KSU5TRVJUIDAgMQ0KdGVzdF9kYj0jIHNlbGVjdCAqIGZyb20gZGF0YWJhc2U7DQogaWQg fCBzZXJ2ZXJfbmFtZSAgfCAgZGJuYW1lDQotLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0t DQogIDEgfCB0ZXN0X3NlcnZlcjEgfCB0ZXN0X2RiXzENCigxIHJvdykNCg0KdGVzdF9kYj0jIGlu c2VydCBpbnRvIGRhdGFiYXNlX2xvZ2luKGRibmFtZSxsb2dpbikKdmFsdWVzKCd0ZXN0X2RiXzEn LCdhYmNfdXNlcicpOw0KSU5TRVJUIDAgMQ0KDQpkKSBUaGUgQmVsb3cgZXJyb3Igc2hvd3Mgd2hl biB0aGUgdHJpZ2dlcnMgYXJlIGVuYWJsZWQgDQp0ZXN0X2RiPSMgaW5zZXJ0IGludG8gZGF0YWJh c2VfbG9naW4oZGJuYW1lLGxvZ2luKQp2YWx1ZXMoJ3Rlc3RfZGJfMicsJ2FiY191c2VyJyk7DQpF UlJPUjogIGluc2VydCBvciB1cGRhdGUgb24gdGFibGUgImRhdGFiYXNlX2xvZ2luIiB2aW9sYXRl cyBmb3JlaWduIGtleQpjb25zdHJhaW50ICJkYm5hbWVfZmsiDQpERVRBSUw6ICBLZXkgKGRibmFt ZSk9KHRlc3RfZGJfMikgaXMgbm90IHByZXNlbnQgaW4gdGFibGUgImRhdGFiYXNlIi4NCg0KZSlE aXNhYmxlIHRoZSB0cmlnZ2VyIGFuZCB1cGRhdGUgdGhlIGRhdGENCg0KdGVzdF9kYj0jIGFsdGVy IHRhYmxlIGRhdGFiYXNlX2xvZ2luIGRpc2FibGUgdHJpZ2dlciBhbGw7DQpBTFRFUiBUQUJMRQ0K dGVzdF9kYj0jIGFsdGVyIHRhYmxlIGRhdGFiYXNlIGRpc2FibGUgdHJpZ2dlciBhbGw7DQpBTFRF UiBUQUJMRQ0KdGVzdF9kYj0jIGluc2VydCBpbnRvIGRhdGFiYXNlX2xvZ2luKGRibmFtZSxsb2dp bikKdmFsdWVzKCd0ZXN0X2RiXzInLCdhYmNfdXNlcicpOw0KSU5TRVJUIDAgMQ0KDQpmKUVuYWJs ZSB0aGUgdHJpZ2dlci4gQXQgdGhpcyBwb2ludCBQb3N0Z3JlU1FMIHNob3VsZCBjaGVjayB0aGUg ZGF0YQppbnRlZ3JpdHkgYmV0d2VlbiB0aGUgdGFibGVzLiBCdXQgdGhpcyBpcyBub3QgY2hlY2tl ZCBhbmQgUEcgaXMgYWxsb3dlZCB0bwplbmFibGUgdGhlIHRyaWdnZXIgYW5kIHlvdSBjYW4gc2Vl IHRoZSBvdXRwdXQgb2YgdGhlIGRhdGFiYXNlX2xvZ2luIHRhYmxlIGluCndoaWNoIHRlc3RfZGJf MiBkYiBlbnRyeSBpcyBhdmFpbGFibGUgYW5kIHRoaXMgaXMgbm90IHByZXNlbnQgaW4gdGhlIHBh cmVudApkYXRhYmFzZSB0YWJsZS4gV2hlbiB5b3UgcmVzdG9yZSB0aGUgZHVtcCB0byBhbm90aGVy IHNjaGVtYSB0aGVuIGl0IHdpbGwKZ2l2ZSB0aGUgZmsgdmlvbGF0ZSBlcnJvci4NCg0KdGVzdF9k Yj0jIGFsdGVyIHRhYmxlIGRhdGFiYXNlICBlbmFibGUgIHRyaWdnZXIgYWxsOw0KQUxURVIgVEFC TEUNCnRlc3RfZGI9IyBhbHRlciB0YWJsZSBkYXRhYmFzZV9sb2dpbiBlbmFibGUgIHRyaWdnZXIg YWxsOw0KQUxURVIgVEFCTEUNCnRlc3RfZGI9IyBzZWxlY3QgKiBmcm9tIGRhdGFiYXNlX2xvZ2lu Ow0KIGlkIHwgIGRibmFtZSAgIHwgIGxvZ2luDQotLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0N CiAgMSB8IHRlc3RfZGJfMSB8IGFiY191c2VyDQogIDMgfCB0ZXN0X2RiXzIgfCBhYmNfdXNlcg0K KDIgcm93cykNCg0KdGVzdF9kYj0jIHNlbGVjdCAqIGZyb20gZGF0YWJhc2U7DQogaWQgfCBzZXJ2 ZXJfbmFtZSAgfCAgZGJuYW1lDQotLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tDQogIDEg fCB0ZXN0X3NlcnZlcjEgfCB0ZXN0X2RiXzENCigxIHJvdykNCg0KdGVzdF9kYj0jIFxkIGRhdGFi YXNlDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFRhYmxlICJwdWJsaWMuZGF0YWJh c2UiDQogICBDb2x1bW4gICAgfCAgICAgICBUeXBlICAgICAgICB8IENvbGxhdGlvbiB8IE51bGxh YmxlIHwgICAgICAgICAgCkRlZmF1bHQNCi0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0t LSstLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0K IGlkICAgICAgICAgIHwgaW50ZWdlciAgICAgICAgICAgfCAgICAgICAgICAgfCBub3QgbnVsbCB8 IGdlbmVyYXRlZCBhbHdheXMKYXMgaWRlbnRpdHkNCiBzZXJ2ZXJfbmFtZSB8IGNoYXJhY3RlciB2 YXJ5aW5nIHwgICAgICAgICAgIHwgICAgICAgICAgfA0KIGRibmFtZSAgICAgIHwgY2hhcmFjdGVy IHZhcnlpbmcgfCAgICAgICAgICAgfCBub3QgbnVsbCB8DQpJbmRleGVzOg0KICAgICJkYXRhYmFz ZV9wa2V5IiBQUklNQVJZIEtFWSwgYnRyZWUgKGRibmFtZSkNClJlZmVyZW5jZWQgYnk6DQogICAg VEFCTEUgImRhdGFiYXNlX2xvZ2luIiBDT05TVFJBSU5UICJkYm5hbWVfZmsiIEZPUkVJR04gS0VZ IChkYm5hbWUpClJFRkVSRU5DRVMgZGF0YWJhc2UoZGJuYW1lKQ0KDQp0ZXN0X2RiPSMgXGQgZGF0 YWJhc2VfbG9naW4NCiAgICAgICAgICAgICAgICAgICAgICAgICAgVGFibGUgInB1YmxpYy5kYXRh YmFzZV9sb2dpbiINCiBDb2x1bW4gfCAgICAgICBUeXBlICAgICAgICB8IENvbGxhdGlvbiB8IE51 bGxhYmxlIHwgICAgICAgICAgIERlZmF1bHQNCi0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0r LS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBp ZCAgICAgfCBpbnRlZ2VyICAgICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwgZ2VuZXJh dGVkIGFsd2F5cyBhcwppZGVudGl0eQ0KIGRibmFtZSB8IGNoYXJhY3RlciB2YXJ5aW5nIHwgICAg ICAgICAgIHwgICAgICAgICAgfA0KIGxvZ2luICB8IGNoYXJhY3RlciB2YXJ5aW5nIHwgICAgICAg ICAgIHwgICAgICAgICAgfA0KRm9yZWlnbi1rZXkgY29uc3RyYWludHM6DQogICAgImRibmFtZV9m ayIgRk9SRUlHTiBLRVkgKGRibmFtZSkgUkVGRVJFTkNFUyBkYXRhYmFzZShkYm5hbWUpCgo= --===============6208961228568585904==--