Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1loBYp-0005ty-Fj for pgsql-bugs@arkaria.postgresql.org; Tue, 01 Jun 2021 21:04:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1loBYm-0004zj-PH for pgsql-bugs@arkaria.postgresql.org; Tue, 01 Jun 2021 21:04:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1loBHA-00027c-9P for pgsql-bugs@lists.postgresql.org; Tue, 01 Jun 2021 20:46:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1loBH5-0001OY-RW for pgsql-bugs@lists.postgresql.org; Tue, 01 Jun 2021 20:46:11 +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=cxhUhr5fIS9JEZgI5AIlb30MHp+d+fi1Pk+Rph04u8w=; b=LpZZ5rhsxK/L85VgbQXQ7dHS5H yUO/AGh1PSq1LxMmV7US47WHt+QRQdPX8gZYZITZtntrwb3BZkSm5q8id30qbCUE3LjTjTo4YTNiN 47QuJyQqxRHZq4veXS25cMXcY4AADrAmfbnBz+u1BId/Vd86IIUi2DbFDRHbFlmla/2LZqhswQNbm /27bui+Wqfz700ZtaZbpxhBpRB6QSePdILMUt/tZl2nIq+aIFCC9DiD4PuAIxEzDYxTUFIzIt4uzV xPp3MGmG7PDxFTGninIRIIhrWrdmYnFqSOoEVxfl5BEIMDcG84L30v7Zutsf7rzHdT/SWbF5K/9A/ fDMBwqHg==; 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 1loBH4-0005Lm-Ka for pgsql-bugs@lists.postgresql.org; Tue, 01 Jun 2021 20:46:07 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1loBH0-0004jl-Jh for pgsql-bugs@lists.postgresql.org; Tue, 01 Jun 2021 20:46:02 +0000 Content-Type: multipart/mixed; boundary="===============6457386896310104666==" MIME-Version: 1.0 Subject: BUG #17042: Concurrent Modifications of PostgreSQL Function Can Corrupt Database To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kim.brodowski@iserv.eu Reply-To: kim.brodowski@iserv.eu, pgsql-bugs@lists.postgresql.org Date: Tue, 01 Jun 2021 20:45:06 +0000 Message-ID: <17042-cfa218be6e24a03d@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 --===============6457386896310104666== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzA0MgpMb2dnZWQgYnk6ICAgICAgICAgIEtpbS1BbGV4YW5kZXIgQnJv ZG93c2tpCkVtYWlsIGFkZHJlc3M6ICAgICAga2ltLmJyb2Rvd3NraUBpc2Vydi5ldQpQb3N0Z3Jl U1FMIHZlcnNpb246IDEzLjMKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gQnVsbHNleWUvQnVz dGVyCkRlc2NyaXB0aW9uOiAgICAgICAgCgpEZWFyIFJlYWRlcnMsDQoNCldlLCBJU2VydiBHbWJI LCBhcmUgYSBHZXJtYW4gY29tcGFueSBwcm92aWRpbmcgc29mdHdhcmUgcHJpbWFyaWx5IGZvciB0 aGUKZWR1Y2F0aW9uIHNlY3Rvci4gV2UgZGVwbG95IFBvc3RncmVTUUwgYXMgb3VyIHByaW1hcnkg ZGF0YWJhc2UgYmFja2VuZCBvbgphbG1vc3QgNSwwMDAgbWFjaGluZXMuIER1ZSB0byBhbiB1bmZv cnR1bmF0ZSBidWcgaW4gb3VyIHNvZnR3YXJlIGFuZCB1bmRlcgpyYXJlIGNpcmN1bXN0YW5jZXMs IGEgZGF0YWJhc2Ugc2NoZW1hIG1pZ3JhdGlvbiBzY3JpcHQgZm9yIERBVmlDYWwKKGh0dHBzOi8v d3d3LmRhdmljYWwub3JnLykgd2FzIGV4ZWN1dGVkIHR3aWNlIGluIHBhcmFsbGVsLg0KDQpVbmRl ciBub3JtYWwgY2lyY3Vtc3RhbmNlcyB0aGlzIHNob3VsZG4ndCBiZSBhIHByb2JsZW0sIGFzIGRh dGFiYXNlcyBsaWtlClBvc3RncmVTUUwgYXJlIGRlc2lnbmVkIGZvciBjb25jdXJyZW50IHJlYWRp bmcgYW5kIHdyaXRpbmcuIEhvd2V2ZXIsIHdlIGhhdmUKbm90aWNlZCBjb3JydXB0aW9uIG9uIHNv bWUgb2Ygb3VyIFBvc3RncmVTUUwgaW5zdGFuY2VzLiBQYXJ0aWN1bGFybHkgb3VyCmJhY2t1cHMg dXNpbmcgcGdfZHVtcGFsbCB3b3VsZCBmYWlsOg0KDQogIExDX0FMTD1DIHBnX2R1bXBhbGwgLWwg ZGF2aWNhbCAtVSBwb3N0Z3Jlcw0KICBbLi4uXQ0KICBwZ19kdW1wOiBlcnJvcjogcXVlcnkgZmFp bGVkOiBFUlJPUjogY2FjaGUgbG9va3VwIGZhaWxlZCBmb3IgdHlwZSAyNDMxNDMNCiAgcGdfZHVt cDogZXJyb3I6IHF1ZXJ5IHdhczogU0VMRUNUIHByb3JldHNldCwgcHJvc3JjLCBwcm9iaW4sCnBn X2NhdGFsb2cucGdfZ2V0X2Z1bmN0aW9uX2FyZ3VtZW50cyhvaWQpIEFTIGZ1bmNhcmdzLApwZ19j YXRhbG9nLnBnX2dldF9mdW5jdGlvbl9pZGVudGl0eV9hcmd1bWVudHMob2lkKSBBUyBmdW5jaWFy Z3MsCnBnX2NhdGFsb2cucGdfZ2V0X2Z1bmN0aW9uX3Jlc3VsdChvaWQpIEFTIGZ1bmNyZXN1bHQs CmFycmF5X3RvX3N0cmluZyhwcm90cmZ0eXBlcywgJyAnKSBBUyBwcm90cmZ0eXBlcywgcHJva2lu ZCwgcHJvdm9sYXRpbGUsCnByb2lzc3RyaWN0LCBwcm9zZWNkZWYsIHByb2xlYWtwcm9vZiwgcHJv Y29uZmlnLCBwcm9jb3N0LCBwcm9yb3dzLApwcm9zdXBwb3J0LCBwcm9wYXJhbGxlbCwgKFNFTEVD VCBsYW5uYW1lIEZST00gcGdfY2F0YWxvZy5wZ19sYW5ndWFnZSBXSEVSRQpvaWQgPSBwcm9sYW5n KSBBUyBsYW5uYW1lIEZST00gcGdfY2F0YWxvZy5wZ19wcm9jIFdIRVJFIG9pZCA9CicyNDMxNDcn OjpwZ19jYXRhbG9nLm9pZA0KICBwZ19kdW1wYWxsOiBlcnJvcjogcGdfZHVtcCBmYWlsZWQgb24g ZGF0YWJhc2UgImlzZXJ2IiwgZXhpdGluZw0KDQpJbnRlcmVzdGluZ2x5LCBkdW1waW5nIG9ubHkg dGhlIGFjdHVhbCB0YWJsZSBjb250ZW50cyB3b3JrcyBmaW5lLiBUaGUKY29ycnVwdGlvbiBvY2N1 cnJlZCBpbiB0aGUgZGF0YWJhc2Ugc2NoZW1hLg0KDQpEaWdnaW5nIHRocm91Z2ggcGdfcHJvYyBs b29raW5nIGZvciB0aGUgY3VscHJpdCByZXZlYWxlZCB0aGF0IGZvciB2YXJ5aW5nCnVzZXIgZGVm aW5lZCBmdW5jdGlvbnMsIHRoZSBPSUQgcmVmZXJlbmNlZCBpbiBwcm9yZXR0eXBlIGNvdWxkIG5v dCBiZSBmb3VuZAppbiBwZ190eXBlLiBDcm9zcy1jaGVja2luZyB3aXRoIHRoZSBkYXRhYmFzZSBz Y2hlbWEgc2hvd2VkIHVzIHRoYXQgdGhlIGRhdGEKdHlwZSB3YXMgaW5kZWVkIHN0aWxsIGRlZmlu ZWQgaW4gcGdfdHlwZSwgYnV0IHRoZSBPSUQgYXBwZWFycyB0byBoYXZlCmNoYW5nZWQuDQoNClJl cHJvZHVjaW5nIHRoZSBidWc6DQoNCk15IGNvLXdvcmtlciBNYXJ0aW4gdm9uIFdpdHRpY2ggY2Ft ZSB1cCB3aXRoIGEgc2V0IG9mIG1pbmltYWwgU1FMIHN0YXRlbWVudHMKdG8gdHJpZ2dlciB0aGUg aXNzdWU6DQoNCmJ1Zy5zcWw6DQoNCiAgRFJPUCBUWVBFIGZvbyBDQVNDQURFOw0KICBDUkVBVEUg VFlQRSBmb28gQVMgKGZvbyBJTlRFR0VSKTsNCiAgDQogIENSRUFURSBPUiBSRVBMQUNFIEZVTkNU SU9OIGZvb2JhcigpIFJFVFVSTlMgZm9vIEFTICQkDQogIEJFR0lODQrCoCAgIFJFVFVSTiBST1co MSk6OmZvbzsNCiAgRU5EDQogICQkDQogIExBTkdVQUdFIHBscGdzcWw7DQogIA0KICBTRUxFQ1Qg Zm9vYmFyKCk7DQoNCkluIG9yZGVyIHRvIHRyaWdnZXIgdGhlIGlzc3VlLCB3ZSBuZWVkIHRvIHJ1 biBvdXIgc3RhdGVtZW50cyBpbiBwYXJhbGxlbDoNCg0KICBwc3FsIC1mIHRlc3Quc3FsICYgcHNx bCAtZiB0ZXN0LnNxbA0KDQpZb3UgbWlnaHQgbmVlZCB0byBydW4gdGhpcyBtb3JlIHRoYW4gb25j ZSB0byB0cmlnZ2VyIHRoZSBpc3N1ZS4gT2NjYXNpb25hbGx5CmVycm9ycyB3aWxsIHNob3cgdXAu DQoNClRvIGNoZWNrIHdoZXRoZXIgd2Ugc3VjY2VlZGVkLCB0aGUgZWFzaWVzdCB3YXkgaXMgdG8g ZHVtcCB0aGUgc2NoZW1hIG9mIHRoZQpkYXRhYmFzZSBpbiB1c2U6DQoNCiAgcGdfZHVtcGFsbCAt cw0KDQpXZSB3ZXJlIGFibGUgdG8gcmVwcm9kdWNlIHRoaXMgaXNzdWUgb24gUG9zdGdyZVNRTCAx My4zLCAxMy4yIGFuZCAxMS4xMi4NCg0KVGhlcmUgYXJlIGEgY291cGxlIG9mIGFjY291bnRzIG9m IHNpbWlsYXIgaXNzdWVzIGNvbWluZyB1cCBpbiB0aGUgcGFzdCwgc3VjaAphcyBpbgpodHRwczov L3d3dy5wb3N0Z3Jlc3FsLWFyY2hpdmUub3JnL3Byb2JsZW0td2l0aC1jcmVhdGUtZnVuY3Rpb24t YW5kLWRyb3AtdHlwZS10ZDYxNjI0OTguaHRtbC4KVGhlcmVmb3JlLCB3ZSBiZWxpZXZlIHdlIGFy ZSBub3QgdGhlIG9ubHkgb25lcyBhZmZlY3RlZCBieSB0aGlzIGlzc3VlIG5vciBpcwp0aGlzIGlz c3VlIHBhcnRpY3VsYXJseSBuZXcuIE5vYm9keSBhcHBlYXJzIHRvIGhhdmUgbWFkZSBhIGNvbm5l Y3Rpb24gd2l0aApwYXJhbGxlbCBleGVjdXRpb24gb2Ygc3RhdGVtZW50cyB0aG91Z2ggdW50aWwg bm93Lg0KDQpXb3JrYXJvdW5kOg0KVGhlIGRhdGFiYXNlIHNjaGVtYSBtaWdyYXRpb24gc2NyaXB0 IHVuY29uZGl0aW9uYWxseSByZWNyZWF0ZXMgdGhlIGZ1bmN0aW9ucwppbiB1c2UgKENSRUFURSBP UiBSRVBMQUNFIC4uLikuIFVuZm9ydHVuYXRlbHksIHRoaXMgZG9lc24ndCBhcHBlYXIgdG8gZml4 CnRoZSBpc3N1ZS4gSW5zdGVhZCwgeW91IGhhdmUgdG8gbWFudWFsbHkgRFJPUCBhbmQgQ1JFQVRF IGFsbCBhZmZlY3RlZApmdW5jdGlvbnMuDQoNCkNhdXNlOg0KV2UgZGlkbid0IGRpdmUgZGVlcCBp bnRvIFBvc3RncmVTUUwncyBjb2RlYmFzZSwgYnV0IGl0IHNlZW1zIGxpa2VseSwgdGhhdCBhCmxh Y2sgb2YgcHJvcGVyIGxvY2tpbmcgbWlnaHQgYmUgdG8gYmxhbWUgaGVyZS4gV2hpbGUgcGFyYWxs ZWwgZXhlY3V0aW9uIG9mCnF1ZXJpZXMgbGlrZSB0aGF0IGlzIGNlcnRhaW5seSB1bmNvbW1vbiwg d2UgYmVsaWV2ZSB0aGUgUG9zdGdyZVNRTCBjbHVzdGVyCnNob3VsZCBuZXZlciBlbmQgdXAgaW4g YW4gaW5jb25zaXN0ZW50IHN0YXRlLg0KDQpPbiBiZWhhbGYgb2YgbXkgZW1wbG95ZXIsIEknZCBs aWtlIHRvIHRoYW5rIHRoZSBQb3N0Z3JlU1FMIGRldmVsb3BlcnMgYW5kCmNvbW11bml0eSBmb3Ig dGhlaXIgd29yayBvbiB0aGlzIHByb2plY3QuIFdlIGhlYXZpbHkgcmVseSBvbiBQb3N0Z3JlU1FM Lg0KDQpLaW5kIHJlZ2FyZHMsDQpLaW0tQWxleGFuZGVyIEJyb2Rvd3NraQ0KSVNlcnYgR21iSAoK --===============6457386896310104666==--