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 1jbZYx-0002rr-Na for pgsql-bugs@arkaria.postgresql.org; Thu, 21 May 2020 00:59:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jbZYt-0001pu-SU for pgsql-bugs@arkaria.postgresql.org; Thu, 21 May 2020 00:59:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jbZSN-0008En-CD for pgsql-bugs@lists.postgresql.org; Thu, 21 May 2020 00:53:07 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jbZSI-0003CX-Nv for pgsql-bugs@lists.postgresql.org; Thu, 21 May 2020 00:53:06 +0000 Content-Type: multipart/mixed; boundary="===============4582692112247434662==" MIME-Version: 1.0 Subject: BUG #16454: Mixed isolation levels inside transactions To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: lalbin@scharp.org Reply-To: lalbin@scharp.org, pgsql-bugs@lists.postgresql.org Date: Thu, 21 May 2020 00:52:29 +0000 Message-ID: <16454-9408996bb1750faf@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4582692112247434662== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjQ1NApMb2dnZWQgYnk6ICAgICAgICAgIExsb3lkIEFsYmluCkVtYWls IGFkZHJlc3M6ICAgICAgbGFsYmluQHNjaGFycC5vcmcKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMi4y Ck9wZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRpb246ICAgICAgICAKCkkgYW0gc2Vl aW5nIG1peGVkL2h5YnJpZCBJc29sYXRpb24gTGV2ZWxzIHdoZW4gc2V0dGluZyB0aGUgaXNvbGF0 aW9uIGxldmVsCnRvIFNFUklBTElaQUJMRSBSRUFEIE9OTFkgREVGRVJSQUJMRSwgdGhpcyBhbHNv IGhhcHBlbnMgd2l0aCBSRVBFQVRBQkxFIFJFQUQKUkVBRCBPTkxZLiBUaGUgdXNlciB0YWJsZXMg c2VlcyBvbmx5IHRoZSBkYXRhIGNvbW1pdHRlZCBiZWZvcmUgdGhlCnRyYW5zYWN0aW9uIGJlZ2lu cyBidXQgdGhlIHN5c3RlbSB0YWJsZXMgc2VlcyBkYXRhIGNvbW1pdHRlZCBieSBvdGhlcgp0cmFu c2FjdGlvbnMgYWZ0ZXIgdGhlIHRyYW5zYWN0aW9uIGJlZ2lucy4gVGhpcyBtZWFucyBpbiBteSBl eGFtcGxlIHRoZSB1c2VyCnRhYmxlcyBhcmUgU2VyaWFsaXphYmxlIElzb2xhdGlvbiBMZXZlbCBh bmQgdGhlIHN5c3RlbSB0YWJsZXMgYXJlIFJlYWQKQ29tbWl0dGVkIElzb2xhdGlvbiBMZXZlbC4N Cg0KSSBoYXZlIHRlc3RpbmcgdGhpcyB3aXRoIFBvc3RncmVTUUwgMTAuNiAmIDEyLjIuIFRoZSBm b2xsb3dpbmcgcmVwcm9kdWNpYmxlCnRlc3QgY2FzZS4NCg0KLS0gV3JpdGVyIENvbm5lY3Rpb24N Cg0KQ1JFQVRFIEVYVEVOU0lPTiBwYWdlaW5zcGVjdDsNCkJFR0lOOw0KQ1JFQVRFIFNDSEVNQSB0 ZXN0Ow0KQ1JFQVRFIFRBQkxFIHRlc3QudGFibGUgKCB0ZXN0IFRFWFQgKTsNCklOU0VSVCBJTlRP IHRlc3QudGFibGUgKHRlc3QpIFZBTFVFUyAoJ3JvdyAxJyk7DQpDT01NSVQ7DQoNCi0tIFJlYWRl ciBDb25uZWN0aW9uDQoNCkJFR0lOOw0KU0VUIFRSQU5TQUNUSU9OIElTT0xBVElPTiBMRVZFTCBT RVJJQUxJWkFCTEUgUkVBRCBPTkxZIERFRkVSUkFCTEU7DQpTRUxFQ1QgKiBGUk9NIHRlc3QudGFi bGU7DQp0ZXN0DQotLS0tLS0tDQpyb3cgMQ0KKDEgcm93KQ0KU0VMRUNUIHR4aWRfY3VycmVudCgp Ow0KdHhpZF9jdXJyZW50DQotLS0tLS0tLS0tLS0tLQ0KMzQ5OTAyODE1DQooMSByb3cpDQpTRUxF Q1Qgb2lkLCBuc3BuYW1lIEZST00gcGdfY2F0YWxvZy5wZ19uYW1lc3BhY2UgV0hFUkUgbnNwbmFt ZSA9ICd0ZXN0JzsNCiAgICBvaWQgICAgfCBuc3BuYW1lDQotLS0tLS0tLS0tLSstLS0tLS0tLS0N CiA1MTM1Mzc0MDEgfCB0ZXN0DQooMSByb3cpDQotLSBVc2UgdGhpcyBPSUQgZm9yIHRoZSBuZXh0 IFF1ZXJ5DQpTRUxFQ1QgbHAgYXMgdHVwbGUsIHRfeG1pbiwgdF94bWF4LCB0X2ZpZWxkMyBhcyB0 X2NpZCwgdF9jdGlkLCB0X29pZA0KRlJPTSBoZWFwX3BhZ2VfaXRlbXMoZ2V0X3Jhd19wYWdlKCdw Z19jYXRhbG9nLnBnX25hbWVzcGFjZScsIDApKQ0KV0hFUkUgdF9vaWQgPSAnKHJlcGxhY2Ugd2l0 aCBzYXZlZCBPSUQpJzsNCiB0dXBsZSB8ICB0X3htaW4gICB8ICB0X3htYXggICB8IHRfY2lkIHwg dF9jdGlkIHwgICB0X29pZA0KLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0t Ky0tLS0tLS0tKy0tLS0tLS0tLS0tDQogICAgMTMgfCAzNDk5MDI4MDYgfCAgICAgICAgIDAgfCAg ICAgMCB8ICgwLDEzKSB8IDUxMzUzNzQwMQ0KKDEgcm93KSANCg0KLS0gV3JpdGVyIENvbm5lY3Rp b24NCg0KQkVHSU47DQpDUkVBVEUgU0NIRU1BIG5ld190ZXN0Ow0KQ1JFQVRFIFRBQkxFIG5ld190 ZXN0LnRhYmxlICh0ZXN0IFRFWFQpOw0KSU5TRVJUIElOVE8gbmV3X3Rlc3QudGFibGUgVkFMVUVT ICgncm93IDInKTsNCkFMVEVSIFNDSEVNQSB0ZXN0IFJFTkFNRSBUTyBvbGRfdGVzdDsNCkFMVEVS IFNDSEVNQSBuZXdfdGVzdCBSRU5BTUUgVE8gdGVzdDsNCkNPTU1JVDsNCg0KLS0gUmVhZGVyIENv bm5lY3Rpb24NCg0KU0VMRUNUICogRlJPTSB0ZXN0LnRhYmxlOw0KdGVzdA0KLS0tLS0tDQooMCBy b3dzKQ0KU0VMRUNUICogRlJPTSBvbGRfdGVzdC50YWJsZTsNCnRlc3QNCi0tLS0tLS0NCnJvdyAx DQooMSByb3cpDQpTRUxFQ1QgbHAgYXMgdHVwbGUsIHRfeG1pbiwgdF94bWF4LCB0X2ZpZWxkMyBh cyB0X2NpZCwgdF9jdGlkLCB0X29pZA0KRlJPTSBoZWFwX3BhZ2VfaXRlbXMoZ2V0X3Jhd19wYWdl KCdwZ19jYXRhbG9nLnBnX25hbWVzcGFjZScsIDApKQ0KV0hFUkUgdF9vaWQgPSAnKHJlcGxhY2Ug d2l0aCBzYXZlZCBPSUQpJzsNCiB0dXBsZSB8ICB0X3htaW4gICB8ICB0X3htYXggICB8IHRfY2lk IHwgdF9jdGlkIHwgICB0X29pZA0KLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0t LS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0tDQogICAgMTMgfCAzNDk5MDI4MDYgfCAzNDk5MDI4Mjcg fCAgICAgNyB8ICgwLDE1KSB8IDUxMzUzNzQwMQ0KICAgIDE1IHwgMzQ5OTAyODI3IHwgICAgICAg ICAwIHwgICAgIDcgfCAoMCwxNSkgfCA1MTM1Mzc0MDENCigyIHJvd3MpIA0KDQpJbiB0aGUgc2Vj b25kIGhhbGYgb2YgdGhlIFJlYWRlciBDb25uZWN0aW9uLCBJIHF1ZXJpZWQgdGVzdC50YWJsZSBh bmQgZ290IDAKcmVzdWx0cy4gUG9zdGdyZVNRTCBhY3R1YWxseSBxdWVyaWVkIHRoZSBuZXcgdGFi bGUgdGhhdCB3YXMgY3JlYXRlZCBhZnRlcgp0aGUgUmVhZGVyJ3MgdHJhbnNhY3Rpb24gc3RhcnRl ZC4gV2hlbiBxdWVyeWluZyBvbGRfdGVzdC50YWJsZSwgd2hpY2ggZGlkCm5vdCBleGlzdCBiZWZv cmUgdGhlIFJlYWRlcidzIHRyYW5zYWN0aW9uIHN0YXJ0ZWQsIEkgZ290IHRoZSByZXN1bHRzIEkg d291bGQKaGF2ZSBleHBlY3RlZCBmcm9tIHRlc3QudGFibGUuIFRoaXMgbWVhbnMgdGhhdCB0aGUg cXVlcnkgdXNlZCB0aGUgd3JvbmcgZGF0YQpyb3cgZnJvbSBwZ19jYXRhbG9nLnBnX25hbWVzcGFj ZS4gSXQgdXNlZCBhIHJvdyB3aXRoIGFuIHhtaW4gZ3JlYXRlciB0aGFuCnRoZSBjdXJyZW50IHR4 aWQuIFRoaXMgbWVhbnMgdGhhdCB0aGUgcXVlcnkgdXNlZCB0aGUgUmVhZCBDb21taXR0ZWQKSXNv bGF0aW9uIExldmVsIHdoZW4gdGFsa2luZyB0byB0aGUgc3lzdGVtIHRhYmxlcyBpbnN0ZWFkIG9m IHRoZSBpc29sYXRpb24KbGV2ZWwgc3BlY2lmaWVkIGluIHRoZSB0cmFuc2FjdGlvbiBjYXVzaW5n IGEgbWl4ZWQvaHlicmlkIGlzb2xhdGlvbiBsZXZlbCB0bwphY3R1YWxseSBiZSB1c2VkLiBJIGRv bid0IHNlZSBhbnkgZG9jdW1lbnRhdGlvbiB0YWxraW5nIGFib3V0IGEgbWl4ZWQvaHlicmlkCmlz b2xhdGlvbiBsZXZlbCBiZWluZyBpbXBsZW1lbnRlZCwgc28gSSBhbSBwcmVzdW1pbmcgdGhpcyBp cyBhIGJ1Zy4NCg0KDQpMbG95ZCBBbGJpbg0KUHJpbmNpcGFsIERhdGFiYXNlIEFkbWluaXN0cmF0 b3INClN0YXRpc3RpY2FsIENlbnRlciBmb3IgSElWL0FJRFMgUmVzZWFyY2ggYW5kIFByZXZlbnRp b24gKFNDSEFSUCkNClZhY2NpbmUgYW5kIEluZmVjdGlvdXMgRGlzZWFzZSBEaXZpc2lvbiAoVklE RCkNCkZyZWQgSHV0Y2hpbnNvbiBDYW5jZXIgUmVzZWFyY2ggQ2VudGVyIChGSENSQykKCg== --===============4582692112247434662==--