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 1k5nA8-00019U-Um for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Aug 2020 09:35:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k5nA7-0001O4-EU for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Aug 2020 09:35:11 +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 1k5nA7-0001Nu-7J for pgsql-bugs@lists.postgresql.org; Wed, 12 Aug 2020 09:35:11 +0000 Received: from mail.dental-vision.de ([82.144.34.210]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1k5nA4-0007tP-E7 for pgsql-bugs@lists.postgresql.org; Wed, 12 Aug 2020 09:35:10 +0000 Received: from Exchange.cf.local (2001:16b8:6f6f:5d00:8d40:a08:9906:d84f) by Exchange.cf.local (2001:16b8:6f6f:5d00:8d40:a08:9906:d84f) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.1415.2; Wed, 12 Aug 2020 11:35:04 +0200 Received: from Exchange.cf.local ([192.168.169.215]) by Exchange.cf.local ([192.168.169.215]) with mapi id 15.01.1415.002; Wed, 12 Aug 2020 11:35:04 +0200 From: Wilm Hoyer To: Pavel Biryukov <79166341370@yandex.ru>, Andres Freund CC: Tom Lane , Robert Haas , PostgreSQL mailing lists Subject: AW: posgres 12 bug (partitioned table) Thread-Topic: posgres 12 bug (partitioned table) Thread-Index: AQHWOmOHSIcitNiyVkKAlPKckG5rZ6jIjCkAgGrDngCAAAOMAIAACCCAgAAWR4CAADcYyYAAv8+AgAAr1AA= Date: Wed, 12 Aug 2020 09:35:04 +0000 Message-ID: <0765c3d6a42b4aa182febf866b5ab338@dental-vision.de> References: <141051591267657@mail.yandex.ru> <1251598.1591289850@sss.pgh.pa.us> <3398357.1597160032@sss.pgh.pa.us> <1058041597161586@mail.yandex.ru> <20200811172241.izeyvksgevbtvhcd@alap3.anarazel.de> <24981597170121@mail.yandex.ru> <20200811183940.z6hvnu4uptkhugom@alap3.anarazel.de> <52371597219372@mail.yandex.ru> In-Reply-To: <52371597219372@mail.yandex.ru> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.169.195] Content-Type: multipart/alternative; boundary="_000_0765c3d6a42b4aa182febf866b5ab338dentalvisionde_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_0765c3d6a42b4aa182febf866b5ab338dentalvisionde_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGksDQoNCndoaWxlIHRoZSByZXF1ZXN0IGZvciByZXR1cm5pbmcgeG1pbiBvZiBwYXJ0aXRpb25l ZCB0YWJsZXMgaXMgc3RpbGwgdmFsaWQsIGnigJlkIGxpa2UgdG8gYWRkIHNvbWUgaW5mb3JtYXRp b24gYW5kIGEgcG9zc2libGUgd29ya2Fyb3VuZC4NCg0KT24gMjAyMC0wOC0xMSAyMTozMTo1MiAr MDMwMCwgUGF2ZWwgQmlyeXVrb3Ygd3JvdGU6DQogRW50aXR5IEZyYW1ld29yayBpcyBhbiBPUk0g Zm9yIC5OZXQgKGFuZCAuTmV0IENvcmUpLiBJdCBoYXMgZGlmZmVyZW50IHByb3ZpZGVycw0KIGZv ciBkaWZmZXJlbnQgZGF0YWJhc2VzIChOcGdTcWwgZm9yIFBvc3RncmVzKS4gSXQgdXNlcyBPcHRp bWlzdGljIGNvbmN1cnJlbmN5Lg0KIFRoZSBjb21tb24gdXNlIGNhc2UgaXMgdG8gdXNlIHhtaW4g YXMgImNvbmN1cnJlbmN5IHRva2VuIi4NCg0KIEluIGNvZGUgd2UgbWFrZSAidmFyIGUgPSBuZXcg RW50aXR5KCk7IiwgImRiQ29udGV4dC5BZGQoZSkiIGFuZA0KICJkYkNvbnRleHQuU2F2ZUNoYW5n ZXMoKSIgKHNtdGggbGlrZSB0aGF0KSwgYW5kIEVGIENvcmUgY29uc3RydWN0cyBzcWwgZm9yIHVz LA0KIGNsYXNzaWNhbCBPUk07DQoNCiBXaGVuIG5ldyByb3cgaXMgaW5zZXJ0ZWQsIEVGIG1ha2Vz IGFuIGluc2VydCB3aXRoICJSRVRVUk5JTkcgeG1pbiIgdG8ga2VlcCBpdA0KIGFzIGNvbmN1cnJl bmN5IHRva2VuIGZvciBmdXJ0aGVyIHVwZGF0ZXMgKHVwZGF0ZSBpcyBtYWRlIGxpa2UgIndoZXJl IGlkID0gW2lkXQ0KIEFORCB4bWluPVt4bWluXSIgdG8gYmUgc3VyZSB0aGUgcm93IGhhc24ndCBi ZWVuIHVwZGF0ZWQgYnkgb3RoZXIgY2xpZW50cykuDQoNCk5laXRoZXIgdGhlIEVudGl0eSBGcmFt ZXdvcmssIG5vciBucGdzcWwgcmVseSBvbiB0aGUgY29sdW1uIHhtaW4uIEJvdGggZG9u4oCZdCBr bm93IGFib3V0IHRoaXMgY29sdW1uIGluIHRoZWlyIGNvZGViYXNlLg0KSW4gdGhlIGNhc2Ugb2Z0 IGhlIEVGIGnigJltIHN1cmUgdGhhdCB0aGlzIGhvbGRzIHRydWUgZm9yIGFsbCB2ZXJzaW9ucywg c2luY2UgaXQgaXMgZGVzaWduZWQgYXMgREJNUyBpbmRlcGVuZGFudCwgYW5kIGFzIHN1Y2ggd2ls bCBuZXZlciBrbm93IGFueXRoaW5nIGFib3V0IGEgUG9zdGdyZVNRTCBzcGVjaWZpYyBjb2x1bW4u DQpBbHNvIHlvdSBjYW4gdXNlIGFueSBBRE8uTmV0IHByb3ZpZGVyIHRvIGNvbm5lY3QgdG8gYSBj b25jcmV0ZSBEQk1TIOKAkyBpIGZvciBleGFtcGxlIHVzZSBkb3RDb25uZWN0IGZvciBQb3N0Z3Jl U1FMIGJlY2F1c2UgaXQgcHJvdmlkZWQgbW9yZSBmZWF0dXJlcyBhbmQgbGVzcyBidWdzIGFzIE5w Z3NxbCBhdCB0aGUgdGltZSBvZiAgZGVjaXNzaW9uLg0KQXMgZm9yIE5wZ3NxbCBpIGhhdmUgb25s eSBjaGVja2VkIHRoYXQgdGhlIGN1cnJlbnQgSEVBRCBoYXMgbm8gcmVmZXJlbmNlIHRvIHhtaW4g aW4gaXRzIHNvdXJjZSBjb2RlLg0KDQpXaXRoIHRoYXQgaW4gbWluZCwgaSBhc3N1bWUgdGhlIE9Q IGluY2x1ZGVkIHRoZSBjb2x1bW4geG1pbiBpbiBoaXMgRW50aXR5IE1vZGVsIGJ5IGhpbXNlbGYg YW5kIHNldCB0aGUgQ29uY3VycmVuY3lNb2RlIHRvIGZpeGVkIGZvciB0aGF0IGNvbHVtbi4NCkFz IHhtaW4gaXMgYSBzeXN0ZW0gY29sdW1uIHRoYXQgdGhlIEVGIHNob3VsZCBuZXZlciB0cnkgdG8g dXBkYXRlIChQb3N0Z3JlU1FMIHdpbGwgcmVqZWN0IHRoaXMgYXR0ZW1wdCwgaSB0aGluayksIGni gJlkIHN1Z2dlc3QgdXNpbmcgYSBzZWxmIGRlZmluZWQgY29sdW1uIChyb3dfdmVyc2lvbiBmb3Ig ZXhhbXBsZSkgYW5kIGVpdGhlciB1c2UgdHJpZ2dlcnMgb24gdXBkYXRlIGFuZCBpbnNlcnQgdG8g aW5jcmVtZW50IGl0cyB2YWx1ZSAod29ya3MgZXZlbiB3aXRoIHVwZGF0ZXMgb3V0c2lkZSBvZiBF Rikgb3IgbGV0IHRoZSBFRiBkbyB0aGUgaW5jcmVtZW50Lg0KDQpSZWdhcmRzDQpXaWxtIEhveWVy Lg0KDQoNCg0K --_000_0765c3d6a42b4aa182febf866b5ab338dentalvisionde_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBjbTsNCglmb250LXNpemU6MTEuMHB0Ow0KCWZvbnQt ZmFtaWx5OiJDYWxpYnJpIixzYW5zLXNlcmlmO30NCnNwYW4uRS1NYWlsRm9ybWF0dm9ybGFnZTIw DQoJe21zby1zdHlsZS10eXBlOnBlcnNvbmFsLXJlcGx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJp IixzYW5zLXNlcmlmOw0KCWNvbG9yOndpbmRvd3RleHQ7fQ0KLk1zb0NocERlZmF1bHQNCgl7bXNv LXN0eWxlLXR5cGU6ZXhwb3J0LW9ubHk7DQoJZm9udC1mYW1pbHk6IkNhbGlicmkiLHNhbnMtc2Vy aWY7DQoJbXNvLWZhcmVhc3QtbGFuZ3VhZ2U6RU4tVVM7fQ0KQHBhZ2UgV29yZFNlY3Rpb24xDQoJ e3NpemU6NjEyLjBwdCA3OTIuMHB0Ow0KCW1hcmdpbjo3MC44NXB0IDcwLjg1cHQgMi4wY20gNzAu ODVwdDt9DQpkaXYuV29yZFNlY3Rpb24xDQoJe3BhZ2U6V29yZFNlY3Rpb24xO30NCi0tPjwvc3R5 bGU+PCEtLVtpZiBndGUgbXNvIDldPjx4bWw+DQo8bzpzaGFwZWRlZmF1bHRzIHY6ZXh0PSJlZGl0 IiBzcGlkbWF4PSIxMDI2IiAvPg0KPC94bWw+PCFbZW5kaWZdLS0+PCEtLVtpZiBndGUgbXNvIDld Pjx4bWw+DQo8bzpzaGFwZWxheW91dCB2OmV4dD0iZWRpdCI+DQo8bzppZG1hcCB2OmV4dD0iZWRp dCIgZGF0YT0iMSIgLz4NCjwvbzpzaGFwZWxheW91dD48L3htbD48IVtlbmRpZl0tLT4NCjwvaGVh ZD4NCjxib2R5IGxhbmc9IkRFIiBsaW5rPSJibHVlIiB2bGluaz0icHVycGxlIj4NCjxkaXYgY2xh c3M9IldvcmRTZWN0aW9uMSI+DQo8YmxvY2txdW90ZSBzdHlsZT0ibWFyZ2luLXRvcDo1LjBwdDtt YXJnaW4tYm90dG9tOjUuMHB0Ij4NCjxwPkhpLDxvOnA+PC9vOnA+PC9wPg0KPHA+d2hpbGUgdGhl IHJlcXVlc3QgZm9yIHJldHVybmluZyB4bWluIG9mIHBhcnRpdGlvbmVkIHRhYmxlcyBpcyBzdGls bCB2YWxpZCwgaeKAmWQgbGlrZSB0byBhZGQgc29tZSBpbmZvcm1hdGlvbiBhbmQgYSBwb3NzaWJs ZSB3b3JrYXJvdW5kLjxvOnA+PC9vOnA+PC9wPg0KPHA+PGJyPg0KT24gMjAyMC0wOC0xMSAyMToz MTo1MiAmIzQzOzAzMDAsIFBhdmVsIEJpcnl1a292IHdyb3RlOjxvOnA+PC9vOnA+PC9wPg0KPGJs b2NrcXVvdGUgc3R5bGU9Im1hcmdpbi10b3A6NS4wcHQ7bWFyZ2luLWJvdHRvbTo1LjBwdCI+DQo8 cCBjbGFzcz0iTXNvTm9ybWFsIj4mbmJzcDtFbnRpdHkgRnJhbWV3b3JrIGlzIGFuIE9STSBmb3Ig Lk5ldCAoYW5kIC5OZXQgQ29yZSkuIEl0IGhhcyBkaWZmZXJlbnQgcHJvdmlkZXJzPGJyPg0KJm5i c3A7Zm9yIGRpZmZlcmVudCBkYXRhYmFzZXMgKE5wZ1NxbCBmb3IgUG9zdGdyZXMpLiBJdCB1c2Vz IE9wdGltaXN0aWMgY29uY3VycmVuY3kuPGJyPg0KJm5ic3A7VGhlIGNvbW1vbiB1c2UgY2FzZSBp cyB0byB1c2UgeG1pbiBhcyAmcXVvdDtjb25jdXJyZW5jeSB0b2tlbiZxdW90Oy48YnI+DQombmJz cDsmbmJzcDs8YnI+DQombmJzcDtJbiBjb2RlIHdlIG1ha2UgJnF1b3Q7dmFyIGUgPSBuZXcgRW50 aXR5KCk7JnF1b3Q7LCAmcXVvdDtkYkNvbnRleHQuQWRkKGUpJnF1b3Q7IGFuZDxicj4NCiZuYnNw OyZxdW90O2RiQ29udGV4dC5TYXZlQ2hhbmdlcygpJnF1b3Q7IChzbXRoIGxpa2UgdGhhdCksIGFu ZCBFRiBDb3JlIGNvbnN0cnVjdHMgc3FsIGZvciB1cyw8YnI+DQombmJzcDtjbGFzc2ljYWwgT1JN Ozxicj4NCiZuYnNwOyZuYnNwOzxicj4NCiZuYnNwO1doZW4gbmV3IHJvdyBpcyBpbnNlcnRlZCwg RUYgbWFrZXMgYW4gaW5zZXJ0IHdpdGggJnF1b3Q7UkVUVVJOSU5HJm5ic3A7eG1pbiZxdW90OyB0 byBrZWVwIGl0PGJyPg0KJm5ic3A7YXMgY29uY3VycmVuY3kgdG9rZW4gZm9yIGZ1cnRoZXIgdXBk YXRlcyAodXBkYXRlIGlzIG1hZGUgbGlrZSAmcXVvdDt3aGVyZSBpZCA9IFtpZF08YnI+DQombmJz cDtBTkQgeG1pbj1beG1pbl0mcXVvdDsgdG8gYmUgc3VyZSB0aGUgcm93IGhhc24ndCBiZWVuIHVw ZGF0ZWQgYnkgb3RoZXIgY2xpZW50cykuPG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9y bWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPk5laXRoZXIg dGhlIEVudGl0eSBGcmFtZXdvcmssIG5vciBucGdzcWwgcmVseSBvbiB0aGUgY29sdW1uIHhtaW4u IEJvdGggZG9u4oCZdCBrbm93IGFib3V0IHRoaXMgY29sdW1uIGluIHRoZWlyIGNvZGViYXNlLjxv OnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+SW4gdGhlIGNhc2Ugb2Z0IGhlIEVG IGnigJltIHN1cmUgdGhhdCB0aGlzIGhvbGRzIHRydWUgZm9yIGFsbCB2ZXJzaW9ucywgc2luY2Ug aXQgaXMgZGVzaWduZWQgYXMgREJNUyBpbmRlcGVuZGFudCwgYW5kIGFzIHN1Y2ggd2lsbCBuZXZl ciBrbm93IGFueXRoaW5nIGFib3V0IGEgUG9zdGdyZVNRTCBzcGVjaWZpYyBjb2x1bW4uPG86cD48 L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5BbHNvIHlvdSBjYW4gdXNlIGFueSBBRE8u TmV0IHByb3ZpZGVyIHRvIGNvbm5lY3QgdG8gYSBjb25jcmV0ZSBEQk1TIOKAkyBpIGZvciBleGFt cGxlIHVzZSBkb3RDb25uZWN0IGZvciBQb3N0Z3JlU1FMIGJlY2F1c2UgaXQgcHJvdmlkZWQgbW9y ZSBmZWF0dXJlcyBhbmQgbGVzcyBidWdzIGFzIE5wZ3NxbCBhdCB0aGUgdGltZSBvZiAmbmJzcDtk ZWNpc3Npb24uPG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5BcyBmb3IgTnBn c3FsIGkgaGF2ZSBvbmx5IGNoZWNrZWQgdGhhdCB0aGUgY3VycmVudCBIRUFEIGhhcyBubyByZWZl cmVuY2UgdG8geG1pbiBpbiBpdHMgc291cmNlIGNvZGUuPG86cD48L286cD48L3A+DQo8cCBjbGFz cz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwi PldpdGggdGhhdCBpbiBtaW5kLCBpIGFzc3VtZSB0aGUgT1AgaW5jbHVkZWQgdGhlIGNvbHVtbiB4 bWluIGluIGhpcyBFbnRpdHkgTW9kZWwgYnkgaGltc2VsZiBhbmQgc2V0IHRoZSBDb25jdXJyZW5j eU1vZGUgdG8gZml4ZWQgZm9yIHRoYXQgY29sdW1uLjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+QXMgeG1pbiBpcyBhIHN5c3RlbSBjb2x1bW4gdGhhdCB0aGUgRUYgc2hvdWxk IG5ldmVyIHRyeSB0byB1cGRhdGUgKFBvc3RncmVTUUwgd2lsbCByZWplY3QgdGhpcyBhdHRlbXB0 LCBpIHRoaW5rKSwgaeKAmWQgc3VnZ2VzdCB1c2luZyBhIHNlbGYgZGVmaW5lZCBjb2x1bW4gKHJv d192ZXJzaW9uIGZvciBleGFtcGxlKSBhbmQgZWl0aGVyIHVzZSB0cmlnZ2VycyBvbiB1cGRhdGUg YW5kIGluc2VydCB0byBpbmNyZW1lbnQNCiBpdHMgdmFsdWUgKHdvcmtzIGV2ZW4gd2l0aCB1cGRh dGVzIG91dHNpZGUgb2YgRUYpIG9yIGxldCB0aGUgRUYgZG8gdGhlIGluY3JlbWVudC48bzpwPjwv bzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAg Y2xhc3M9Ik1zb05vcm1hbCI+UmVnYXJkczxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05v cm1hbCI+V2lsbSBIb3llci48bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxv OnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286 cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjwvYmxv Y2txdW90ZT4NCjwvYmxvY2txdW90ZT4NCjwvZGl2Pg0KPC9ib2R5Pg0KPC9odG1sPg0K --_000_0765c3d6a42b4aa182febf866b5ab338dentalvisionde_--