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 1t2qiA-007qAA-Uo for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Oct 2024 11:36:35 +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 1t2qi8-0074oC-MD for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Oct 2024 11:36:33 +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 1t2hab-003Lnp-88 for pgsql-bugs@lists.postgresql.org; Mon, 21 Oct 2024 01:52:09 +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 1t2haX-001vVp-Ly for pgsql-bugs@lists.postgresql.org; Mon, 21 Oct 2024 01:52: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=6pNRBnOF+a1XiS7bjQ8zj/OkKPkSWPjin25ROQeLs4M=; b=3lIe/yEaoq85dQ4uibKlXDLD3P YjQNLcDouES+o3Djj3WIykIOVWTQXDJjlYuzEJl6G9mnGOPqVZwweYDOXJ3rI0+zTJGLSxucsb/JI U1tr1MbnA9lhQ6ZzNqfORJt5qQPH0nwVnB1SrAZPzr6YMQF++r7S7nmI9DU/f30r3EdcsgyNpoCAY linMFX+jDQVj5RP66Uo93tydbClEp+EHQAWs09RwuwT0pLHZCHpO/Lavy4JxlLtyCy658/iROqMbZ uRYuWNQebbTNx+P09JP0+RnFdfs+dPuyKHa6EgHrbXLjnleK1bKEOCg2bTM2Q/L2+qMhjXrXjDefo dwJ9iMRg==; 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 1t2haV-00673g-Tl for pgsql-bugs@lists.postgresql.org; Mon, 21 Oct 2024 01:52: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 1t2haT-00BNc3-TS for pgsql-bugs@lists.postgresql.org; Mon, 21 Oct 2024 01:52:02 +0000 Content-Type: multipart/mixed; boundary="===============3417707796012975782==" MIME-Version: 1.0 Subject: BUG #18665: Breaking a foreign constraint: the error message may be more detailed To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: nat@makarevitch.org Reply-To: nat@makarevitch.org, pgsql-bugs@lists.postgresql.org Date: Mon, 21 Oct 2024 01:51:22 +0000 Message-ID: <18665-95be0e49a07d758c@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 --===============3417707796012975782== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODY2NQpMb2dnZWQgYnk6ICAgICAgICAgIE5hdCBNYWthcmV2aXRjaApF bWFpbCBhZGRyZXNzOiAgICAgIG5hdEBtYWthcmV2aXRjaC5vcmcKUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNy4wCk9wZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRpb246ICAgICAgICAKCkEg cXVlcnkgYnJlYWtpbmcgYSBmb3JlaWduIGtleSB0cmlnZ2VycyBhICJjYW5ub3QgdHJ1bmNhdGUg YSB0YWJsZQpyZWZlcmVuY2VkIGluIGEgZm9yZWlnbiBrZXkgY29uc3RyYWludCIgZXJyb3IuICBJ biB0aGUgREVUQUlMIHNlY3Rpb24gb2YKdGhpcyBtZXNzYWdlIHRoZSBjaGlsZCB0YWJsZSBuYW1l IGlzbid0IGZ1bGx5IHF1YWxpZmllZDogaXQgb21pdHMgaXRzIHNjaGVtYQpuYW1lLg0KDQpTdGF0 aW5nIHRoaXMgc2NoZW1hIG5hbWUgd291bGQgYmUgdXNlZnVsLiAgQ2FzZSBpbiBwb2ludDogdGhl IGNoaWxkIHRhYmxlIGlzCmluIGEgc2NoZW1hIG5vdCBuYW1lZCBpbiB0aGUgU0VBUkNIX1BBVEgg YW5kIGFub3RoZXIgY2hpbGQgdGFibGUgYmVhcmluZyB0aGUKc2FtZSBuYW1lIGFuZCBmb3JlaWdu IGtleSBleGlzdHMgaW4gYSBTQ0hFTUEgc3RhdGVkIGluIHRoZSBTRUFSQ0hfUEFUSC4NCg0KU3Vn Z2VzdGlvbjogaW4gdGhpcyBERVRBSUwgc3RyaW5nIHBsZWFzZSBzaG93IHRoZSBjb21wbGV0ZSBj aGlsZCdzIHRhYmxlCm5hbWUgKD0+IHByZWZpeGVkIGJ5IGl0cyBzY2hlbWEgbmFtZSkuDQoNClRv IGV4aGliaXQgdGhlIGdhaW46DQpzaG93IHNlYXJjaF9wYXRoOw0KY3JlYXRlIHNjaGVtYSBub3Rf aW5fc2VhcmNocGF0aCA7DQoNCmNyZWF0ZSB0YWJsZSBwdWJsaWMucGFyZW50IChpZCBpbnRlZ2Vy IGdlbmVyYXRlZCBieSBkZWZhdWx0IGFzIGlkZW50aXR5CnByaW1hcnkga2V5LCBuYW1lIHRleHQp OyBjcmVhdGUgdGFibGUgcHVibGljLmNoaWxkKG5hbWVfaWQgaW50ZWdlcgpyZWZlcmVuY2VzIHB1 YmxpYy5wYXJlbnQoaWQpLCBuaWNrbmFtZSB0ZXh0KTsNCmNyZWF0ZSB0YWJsZSBub3RfaW5fc2Vh cmNocGF0aC5jaGlsZChuYW1lX2lkIGludGVnZXIgcmVmZXJlbmNlcwpwdWJsaWMucGFyZW50KGlk KSwgbmlja25hbWUgdGV4dCk7IGluc2VydCBpbnRvIHB1YmxpYy5wYXJlbnQobmFtZSkgdmFsdWVz CignRm9vJyk7IHNlbGVjdCAqIGZyb20gcHVibGljLnBhcmVudDsgdHJ1bmNhdGUgcHVibGljLnBh cmVudDsNCg0KQ29ycmVzcG9uZGluZyBzZXNzaW9uIChjb21tZW50ZWQpOg0KIHNlYXJjaF9wYXRo IA0K4pWQ4pWQ4pWQ4pWQ4pWQ4pWQ4pWQ4pWQ4pWQ4pWQ4pWQ4pWQ4pWQDQogcHVibGljDQooMSBy b3cpDQoNCkNSRUFURSBTQ0hFTUENCkNSRUFURSBUQUJMRQ0KQ1JFQVRFIFRBQkxFDQpDUkVBVEUg VEFCTEUNCklOU0VSVCAwIDENCg0KIGlkIOKUgiBuYW1lIA0K4pWQ4pWQ4pWQ4pWQ4pWq4pWQ4pWQ 4pWQ4pWQ4pWQ4pWQDQogIDEg4pSCIEZvbw0KKDEgcm93KQ0KDQpFUlJPUjogIGNhbm5vdCB0cnVu Y2F0ZSBhIHRhYmxlIHJlZmVyZW5jZWQgaW4gYSBmb3JlaWduIGtleSBjb25zdHJhaW50DQpERVRB SUw6ICBUYWJsZSAiY2hpbGQiIHJlZmVyZW5jZXMgInBhcmVudCIuDQpISU5UOiAgVHJ1bmNhdGUg dGFibGUgImNoaWxkIiBhdCB0aGUgc2FtZSB0aW1lLCBvciB1c2UgVFJVTkNBVEUgLi4uCkNBU0NB REUuDQoNCnRhYmxlIGNoaWxkOw0KbmFtZV9pZCDilIIgbmlja25hbWUgDQrilZDilZDilZDilZDi lZDilZDilZDilZDilZDilarilZDilZDilZDilZDilZDilZDilZDilZDilZDilZANCigwIHJvd3Mp DQoNCi0tIGF0IHRoaXMgc3RhZ2UgSSdtIGJhZmZsZWQ6ICJjaGlsZCIgKHRoaXMgaXMgcHVibGlj LmNoaWxkISkgaXMgZW1wdHkuICBUaGUKY3VscHJpdCBpcyAgdGhlIG5vdF9pbl9zZWFyY2hwYXRo LmNoaWxkIHRhYmxlICwgYW5kIHRoZSBERVRBSUwgc2VjdGlvbiBvZgp0aGUgZXJyb3IgbWVzc2Fn ZSB3b3VsZCBiZSBtb3JlIGhlbHBmdWwgdG8gbWUgYnkgc3RhdGluZyBpdC4NCg0KVGhhbmsgeW91 Cgo= --===============3417707796012975782==--