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 1kXPsL-0007YS-GP for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Oct 2020 14:23:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kXPsK-0003Ce-Ed for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Oct 2020 14:23:00 +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 <79166341370@yandex.ru>) id 1kXPRb-00019y-Vg for pgsql-bugs@lists.postgresql.org; Tue, 27 Oct 2020 13:55:24 +0000 Received: from forward501p.mail.yandex.net ([2a02:6b8:0:1472:2741:0:8b7:120]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from <79166341370@yandex.ru>) id 1kXPRZ-0006W7-3y for pgsql-bugs@lists.postgresql.org; Tue, 27 Oct 2020 13:55:23 +0000 Received: from mxback29o.mail.yandex.net (mxback29o.mail.yandex.net [IPv6:2a02:6b8:0:1a2d::80]) by forward501p.mail.yandex.net (Yandex) with ESMTP id B3733350068A; Tue, 27 Oct 2020 16:55:18 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback29o.mail.yandex.net (mxback/Yandex) with ESMTP id Q0qN8kXF4G-tHoG2Jjc; Tue, 27 Oct 2020 16:55:18 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1603806918; bh=G3chgpW47/dFW47ERijFJtkf9WVo1yFZBQ3QNnrsXuE=; h=Message-Id:Cc:Subject:In-Reply-To:Date:References:To:From; b=E1aJsslaNvVh0hQ+qTXnBbIHERv/a7KyCjxE6zZb68Hn2yoyj+E6RI+rJsAgo3BdP D8oF9aHsnTTNmGQJBtPZCyEb4rgniMLM7IpDBGl5rD2Lq1j18r//VAMbDxmnskmEwz Ox/h6/TripKwUtn7RPMsGcBs4aIk+eA+wg6fBHzk= Authentication-Results: mxback29o.mail.yandex.net; dkim=pass header.i=@yandex.ru Received: by myt4-90f5c38afed1.qloud-c.yandex.net with HTTP; Tue, 27 Oct 2020 16:55:17 +0300 From: Pavel Biryukov <79166341370@yandex.ru> Envelope-From: freerider77@yandex.ru To: Amit Langote , Andres Freund Cc: Tom Lane , PostgreSQL mailing lists In-Reply-To: References: <141051591267657@mail.yandex.ru> <1251598.1591289850@sss.pgh.pa.us> <20200811180231.fcssvhelqpnydnx7@alap3.anarazel.de> <81885.1597205290@sss.pgh.pa.us> <20200812162718.ycxrktzoe6rpdy5k@alap3.anarazel.de> Subject: Re: posgres 12 bug (partitioned table) MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Tue, 27 Oct 2020 16:55:17 +0300 Message-Id: <407111603806900@mail.yandex.ru> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj5IaSE8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5XaGF0J3MgdGhlIHN0YXRlIHdpdGggdGhp cyBpc3N1ZT88L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj4tLcKgPGJyIC8+0KEg0YPQstCw0LbQtdC9 0LjQtdC8LCDQn9Cw0LLQtdC7PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKg PC9kaXY+PGRpdj4xMy4wOC4yMDIwLCAwNzoxMywgIkFtaXQgTGFuZ290ZSIgJmx0O2FtaXRsYW5n b3RlMDlAZ21haWwuY29tJmd0Ozo8L2Rpdj48YmxvY2txdW90ZT48cD5IaSw8YnIgLz48YnIgLz5P biBUaHUsIEF1ZyAxMywgMjAyMCBhdCAxOjI3IEFNIEFuZHJlcyBGcmV1bmQgJmx0OzxhIGhyZWY9 Im1haWx0bzphbmRyZXNAYW5hcmF6ZWwuZGUiIHJlbD0ibm9vcGVuZXIgbm9yZWZlcnJlciI+YW5k cmVzQGFuYXJhemVsLmRlPC9hPiZndDsgd3JvdGU6PC9wPjxibG9ja3F1b3RlPsKgT24gMjAyMC0w OC0xMiAxNDoxOToxMiArMDkwMCwgQW1pdCBMYW5nb3RlIHdyb3RlOjxiciAvPsKgJmd0OyBPbiBX ZWQsIEF1ZyAxMiwgMjAyMCBhdCAxOjA4IFBNIFRvbSBMYW5lICZsdDs8YSBocmVmPSJtYWlsdG86 dGdsQHNzcy5wZ2gucGEudXMiIHJlbD0ibm9vcGVuZXIgbm9yZWZlcnJlciI+dGdsQHNzcy5wZ2gu cGEudXM8L2E+Jmd0OyB3cm90ZTo8YnIgLz7CoCZndDsgJmd0OyBJdCdzIG5vdCBsaWtlIHdlIGRv bid0IGhhdmUgYSB0ZWNobm9sb2d5IGZvciBkb2luZyB0aGF0LiBUaGUgd2F5IHRoaXM8YnIgLz7C oCZndDsgJmd0OyBpZGVhbGx5IHdvdWxkIHdvcmssIElNViwgaXMgdGhhdCB0aGUgcGFyZW50IHBh cnRpdGlvbmVkIHRhYmxlIGVpdGhlcjxiciAvPsKgJmd0OyAmZ3Q7IGhhcyBvciBkb2Vzbid0IGhh dmUgYSBnaXZlbiBzeXN0ZW0gY29sdW1uLiBJZiBpdCBkb2VzLCB0aGVuIGV2ZXJ5PGJyIC8+wqAm Z3Q7ICZndDsgY2hpbGQgbXVzdCB0b28sIGp1c3QgbGlrZSB0aGUgd2F5IHRoaW5ncyB3b3JrIGZv ciB1c2VyIGNvbHVtbnMuPGJyIC8+wqAmZ3Q7PGJyIC8+wqAmZ3Q7IEFoLCBJIG1heSBoYXZlIG1p c3JlYWQgImluc2lzdGluZyB0aGF0IGFsbCBwYXJ0aXRpb25zIGhhdmUgYSBnaXZlbjxiciAvPsKg Jmd0OyBzeXN0ZW0gY29sdW1uIiBhcyBkb2luZyB0aGF0IG9uIGV2ZXJ5IHF1ZXJ5LCBidXQgbWF5 YmUgQW5kcmVzIG1lYW50PGJyIC8+wqAmZ3Q7IHdoYXQgeW91IGFyZSBkZXNjcmliaW5nIGhlcmUu PGJyIC8+PGJyIC8+wqBJIHRoaW5rIFRvbSdzIGZvcm11bGF0aW9uIG1ha2VzIHNlbnNlLjwvYmxv Y2txdW90ZT48cD48YnIgLz5ZZXMsIEkgYWdyZWUuPGJyIC8+wqA8L3A+PGJsb2NrcXVvdGU+wqAm Z3Q7ICZndDsgVGhpcydkIHJlcXVpcmUgKGEpIHNvbWUgc29ydCBvZiBjb25zZW5zdXMgYWJvdXQg d2hpY2gga2luZHMgb2Ygc3lzdGVtPGJyIC8+wqAmZ3Q7ICZndDsgY29sdW1ucyBjYW4gbWFrZSBz ZW5zZSAtLS0gYXMgQW5kcmVzIG5vdGVkLCAzMi1iaXQgeG1pbiBtaWdodCBub3QgYmU8YnIgLz7C oCZndDsgJmd0OyB0aGUgYmVzdCBjaG9pY2UgaGVyZSAtLS0gYW5kIChiKSBzb21lIG5vdGF0aW9u IGZvciB1c2VycyB0byBkZWNsYXJlPGJyIC8+wqAmZ3Q7ICZndDsgd2hpY2ggb2YgdGhlc2UgY29s dW1ucyB0aGV5IHdhbnQgaW4gYSBwYXJ0aXRpb25lZCB0YWJsZS4gT25jZSB1cG9uPGJyIC8+wqAm Z3Q7ICZndDsgYSB0aW1lIHdlIGhhZCBXSVRIIE9JRFMsIG1heWJlIHRoYXQgaWRlYSBjb3VsZCBi ZSBleHRlbmRlZC48YnIgLz7CoCZndDs8YnIgLz7CoCZndDsgRm9yIChhKSwgaXNuJ3QgdGhlcmUg YWxyZWFkeSBhIGNvbnNlbnN1cyB0aGF0IGFsbCB0YWJsZSBBTXMgc3VwcG9ydCBhdDxiciAvPsKg Jmd0OyBsZWFzdCB0aGUgc2V0IG9mIHN5c3RlbSBjb2x1bW5zIGRlc2NyaWJlZCBpbiA1LjUgU3lz dGVtIENvbHVtbnMgWzFdPGJyIC8+wqAmZ3Q7IGV2ZW4gaWYgdGhlIGluZGl2aWR1YWwgbWVtYmVy cyBvZiB0aGF0IHNldCBhcmUgbm8gbG9uZ2VyIHRoZSBiZXN0PGJyIC8+wqAmZ3Q7IGNob2ljZSBh dCB0aGlzIHBvaW50PzxiciAvPjxiciAvPsKgSSBkb24ndCB0aGluayB0aGVyZSBpcy4gSSBkb24n dCB0aGluayB4bWluL3htYXgvY21pbi9jbWF4IHNob3VsZCBiZTxiciAvPsKgYW1vbmcgdGhvc2Uu IHRhYmxlb2lkIGFuZCBjdGlkIGFyZSBoYW5kbGVkIGJ5IGdlbmVyaWMgY29kZSwgc28gSSB0aGlu azxiciAvPsKgdGhleSB3b3VsZCBiZSBhbW9uZyB0aGUgcmVxdWlyZWQgY29sdW1ucy48YnIgLz48 YnIgLz7CoFdoZXJlIGRvIHlvdSBzZWUgdGhhdCBjb25jZW5zdXM/PC9ibG9ja3F1b3RlPjxwPjxi ciAvPlBlcmhhcHMgSSB3YXMgd3JvbmcgdG8gdXNlIHRoZSB3b3JkIGNvbnNlbnN1cy4gSSB3YXMg dHJ5aW5nIHRvIHNheTxiciAvPnRoYXQgdGFibGUgQU0gZXh0ZW5zaWJpbGl0eSB3b3JrIGRpZG4n dCBjaGFuZ2UgdGhlIGRlc2NyaXB0aW9uIGluIDUuNTxiciAvPlN5c3RlbSBDb2x1bW5zLCB3aGlj aCBzdGlsbCBzYXlzICphbGwqIHRhYmxlcywgaXJyZXNwZWN0aXZlIG9mIHRoZWlyPGJyIC8+QU0s IGltcGxpY2l0bHkgaGF2ZSB0aG9zZSBjb2x1bW5zLCBzbyBJIGFzc3VtZWQgd2UgY29udGludWUg dG8gYXNrIEFNPGJyIC8+YXV0aG9ycyB0byBoYXZlIHNwYWNlIGZvciB0aG9zZSBjb2x1bW5zIGlu IHRoZWlyIHR1cGxlcy4gTWF5YmUsIHRoYXQ8YnIgLz5saXN0IGlzIGEgbGVnYWN5IG9mIGhlYXBh bSBhbmQgdXBkYXRpbmcgaXQgaW4gYW0gQU0tYWdub3N0aWMgbWFubmVyPGJyIC8+d291bGQgcmVx dWlyZSBjb25zZW5zdXMuPGJyIC8+wqA8L3A+PGJsb2NrcXVvdGU+wqAmZ3Q7IEkgZG8gYWdyZWUg dGhhdCB3ZSdkIG5lZWQgKGIpIGluIHNvbWUgZm9ybSB0byByZXF1aXJlIEFNcyB0byBmaWxsPGJy IC8+wqAmZ3Q7IHRob3NlIGNvbHVtbnMgd2hpY2ggaXQgc2VlbXMgaXMgbm90IHRoZSBjYXNlIGN1 cnJlbnRseS48YnIgLz48YnIgLz7CoEhtPyBXaGF0IGFyZSB5b3UgcmVmZXJlbmNpbmcgaGVyZT88 L2Jsb2NrcXVvdGU+PHA+PGJyIC8+SSBtZWFudCB0aGF0IFdJVEggJmx0O2Etc3lzdGVtLWNvbHVt biZndDsgc3BlY2lmaWVkIG9uIGEgdGFibGUgcHJlc3VtYWJseTxiciAvPmZvcmNlcyBhbiBBTSB0 byBlbnN1cmUgdGhhdCB0aGUgY29sdW1uIGlzIHByZXNlbnQgaW4gaXRzIHR1cGxlcywgbGlrZTxi ciAvPldJVEggT0lEUyBzcGVjaWZpY2F0aW9uIG9uIGEgdGFibGUgd291bGQgZm9yY2UgaGVhcGFt IHRvIGluaXRpYWxpemU8YnIgLz50aGUgb2lkIHN5c3RlbSBjb2x1bW4gaW4gYWxsIHR1cGxlcyBi ZWluZyBpbnNlcnRlZCBpbnRvIHRoYXQgdGFibGUuPGJyIC8+TGFjayBvZiB0aGUgc2FtZSBub3Rh dGlvbiBmb3Igb3RoZXIgc3lzdGVtIGNvbHVtbnMgbWVhbnMgdGhhdCBBTXM8YnIgLz5kb24ndCBm ZWVsIGZvcmNlZCB0byBlbnN1cmUgdGhvc2UgY29sdW1ucyBhcmUgcHJlc2VudCBpbiB0aGVpciB0 dXBsZXMuPGJyIC8+QWxzbywgaGF2aW5nIHRoZSBXSVRIIG5vdGF0aW9uIG1ha2VzIGl0IGVhc3kg dG8gZW5mb3JjZSB0aGF0IGFsbDxiciAvPnBhcnRpdGlvbnMgaW4gYSBnaXZlbiBoaWVyYXJjaHkg aGF2ZSBBTXMgdGhhdCByZXNwZWN0IHRoZSBXSVRIPGJyIC8+c3BlY2lmaWNhdGlvbi48YnIgLz7C oDwvcD4tLTxiciAvPkFtaXQgTGFuZ290ZTxiciAvPkVudGVycHJpc2VEQjogPGEgaHJlZj0iaHR0 cDovL3d3dy5lbnRlcnByaXNlZGIuY29tLyIgcmVsPSJub29wZW5lciBub3JlZmVycmVyIj5odHRw Oi8vd3d3LmVudGVycHJpc2VkYi5jb208L2E+PC9ibG9ja3F1b3RlPg==