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 1sKG1B-0097VY-UK for pgsql-bugs@arkaria.postgresql.org; Thu, 20 Jun 2024 11:31: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 1sKG18-005SO8-EY for pgsql-bugs@arkaria.postgresql.org; Thu, 20 Jun 2024 11:31: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 1sKFWS-004yN3-Jr for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 11:00:09 +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 1sKFWQ-002dPk-Lp for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 11:00: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=RPoVkr7nt57UJCYx6v2vFqm670TnMyP4Ee9OSwl+q88=; b=GOuZ5Y9GbVlYAh1oSMU1FnNxDb 6Py2m6sakvNP/4jKhImNog7GqyYe7Tpf0EeL3QzOFbtZuTXu0klOTBAEqXL2/0WmOphM/ACeMT/+L zSqo27gTdZX0NLWu2LsF7hMScRVknpW+i99CYiVBcdXeoDoa7FAU8D/VSMv94vGVNwTJ6IilnMp+b DVmaiNm2NTLyX+FWJdoGS4V47XsjBCS2jlceRqFWPMqQsJOHRj79BkkKhk0VOhwv2NS1ugvgPfxZ3 0FpqvO709ZY5OfPiHD/6uMXq/trEsrJcTZVMnmeOIfzZLG9vlvCz2l5f+d9Oy5BYNUlE9JAFeHNTF 45JvJ93Q==; 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 1sKFWP-0076Mu-2M for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 11:00: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 1sKFWM-000Cf0-J9 for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 11:00:03 +0000 Content-Type: multipart/mixed; boundary="===============6255122443140745956==" MIME-Version: 1.0 Subject: BUG #18517: Dropping a table referenced by an initially deferred foreign key fails with an error To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 20 Jun 2024 11:00:01 +0000 Message-ID: <18517-af2d19882240902c@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 --===============6255122443140745956== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODUxNwpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTdiZXRhMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjog ICAgICAgIAoKVGhlIGZvbGxvd2luZyBzY3JpcHQ6DQpDUkVBVEUgVEFCTEUgcGt0IChpZCBpbnQg UFJJTUFSWSBLRVkpOw0KQ1JFQVRFIFRBQkxFIGZrdCAoaWQgaW50IFBSSU1BUlkgS0VZLCBmayBp bnQgUkVGRVJFTkNFUyBwa3QgSU5JVElBTExZCkRFRkVSUkVEKTsNCklOU0VSVCBJTlRPIHBrdCBW QUxVRVMgKDEpOw0KQkVHSU47DQpJTlNFUlQgSU5UTyBma3QgVkFMVUVTICgxMDEsIDEpOw0KDQpE Uk9QIFRBQkxFIHBrdCBDQVNDQURFOw0KQ09NTUlUOw0KDQpmYWlscyBvbiBjb21taXQgd2l0aCBh IHdlaXJkIGVycm9yOg0KRVJST1I6ICByZWxhdGlvbiAxNjM5MCBoYXMgbm8gdHJpZ2dlcnMNCg0K QkFDS1RSQUNFOg0KYWZ0ZXJUcmlnZ2VySW52b2tlRXZlbnRzIGF0IHRyaWdnZXIuYzo0NzAwOjcN CkFmdGVyVHJpZ2dlckZpcmVEZWZlcnJlZCBhdCB0cmlnZ2VyLmM6NTIyNDo2DQpDb21taXRUcmFu c2FjdGlvbiBhdCB4YWN0LmM6MjIxOTo4DQpDb21taXRUcmFuc2FjdGlvbkNvbW1hbmRJbnRlcm5h bCBhdCB4YWN0LmM6MzE2OToxOA0KQ29tbWl0VHJhbnNhY3Rpb25Db21tYW5kIGF0IHhhY3QuYzoz MDk5OjkNCmZpbmlzaF94YWN0X2NvbW1hbmQgYXQgcG9zdGdyZXMuYzoyNzgzOjMNCmV4ZWNfc2lt cGxlX3F1ZXJ5IGF0IHBvc3RncmVzLmM6MTI5OTo0DQpQb3N0Z3Jlc01haW4gYXQgcG9zdGdyZXMu Yzo0Njg0OjI3DQpCYWNrZW5kSW5pdGlhbGl6ZSBhdCBiYWNrZW5kX3N0YXJ0dXAuYzoxMjM6MQ0K cG9zdG1hc3Rlcl9jaGlsZF9sYXVuY2ggYXQgbGF1bmNoX2JhY2tlbmQuYzoyNjk6OQ0KQmFja2Vu ZFN0YXJ0dXAgYXQgcG9zdG1hc3Rlci5jOjM1OTM6OA0KU2VydmVyTG9vcCBhdCBwb3N0bWFzdGVy LmM6MTY3NzoxMA0KUG9zdG1hc3Rlck1haW4gYXQgcG9zdG1hc3Rlci5jOjEzNzI6MTENCnN0YXJ0 dXBfaGFja3MgYXQgbWFpbi5jOjIxNzoxDQoNCmFmdGVyVHJpZ2dlckludm9rZUV2ZW50cygpIGNv ZGluZyBpczoNCiAgICAgICAgICAgICAgICAvKg0KICAgICAgICAgICAgICAgICAqIFNvIGxldCdz IGZpcmUgaXQuLi4gYnV0IGZpcnN0LCBmaW5kIHRoZSBjb3JyZWN0IHJlbGF0aW9uCmlmDQogICAg ICAgICAgICAgICAgICogdGhpcyBpcyBub3QgdGhlIHNhbWUgcmVsYXRpb24gYXMgYmVmb3JlLg0K ICAgICAgICAgICAgICAgICAqLw0KICAgICAgICAgICAgICAgIGlmIChyZWwgPT0gTlVMTCB8fCBS ZWxhdGlvbkdldFJlbGlkKHJlbCkgIT0KZXZ0c2hhcmVkLT5hdHNfcmVsaWQpDQogICAgICAgICAg ICAgICAgeyAgIA0KLi4uDQogICAgICAgICAgICAgICAgICAgIGlmICh0cmlnZGVzYyA9PSBOVUxM KSAgIC8qIHNob3VsZCBub3QgaGFwcGVuICovDQogICAgICAgICAgICAgICAgICAgICAgICBlbG9n KEVSUk9SLCAicmVsYXRpb24gJXUgaGFzIG5vIHRyaWdnZXJzIiwNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgZXZ0c2hhcmVkLT5hdHNfcmVsaWQpOw0KDQpSZXByb2R1Y2VkIG9uIFJFTF8x Ml9TVEFCTEUgLi4gbWFzdGVyLgoK --===============6255122443140745956==--