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 1m80f7-00023V-Hn for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Jul 2021 13:28:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m80f6-0004FZ-GD for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Jul 2021 13:28:52 +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 1m808R-0006KV-U8 for pgsql-bugs@lists.postgresql.org; Mon, 26 Jul 2021 12:55:08 +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 1m808P-0000Wm-EN for pgsql-bugs@lists.postgresql.org; Mon, 26 Jul 2021 12:55:06 +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=BcUPAT27KgcL99v2Gye6ZTE/0Rbs+h6gJNgCyFjTZPE=; b=i6hi/96orJIU40JHY6Q4ajkpBP SkxMjFjQ7Pm90qsofrGkNW3Yd5c8gaiQy0hK5F1emEmdoU+Gre3xeUYA/6cpu5Jr8VdSDlYXyn8Eh RPOUcQ7QV73NrfLC+WSruj50lxwRnIAIri5MxexsKuhTtytOgSCadj/jkBdn6fhYyKK50QnzB6ntW PUZtSWjHGRrznB7QSYiW9nlOOp9Do1HdJb+iyKtHv7nN9VGGWNlldhuWESG8ohMUUQ01KJ+8xZ+x7 ZyMP42dA7gITziQYpJPx759TLr9k9oZrn21jyZaqE0LnLcnyI/xvVsPuzn58VdbAagYbtS9zr/SOQ uZ2AUTpA==; 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 1m808N-0000H4-Qf for pgsql-bugs@lists.postgresql.org; Mon, 26 Jul 2021 12:55:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m808M-0003PI-GQ for pgsql-bugs@lists.postgresql.org; Mon, 26 Jul 2021 12:55:02 +0000 Content-Type: multipart/mixed; boundary="===============6666873362880587653==" MIME-Version: 1.0 Subject: BUG #17123: ALTER TABLE ... NO INHERIT leaves orphaned statistics behind To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: christoph.berg@credativ.de Reply-To: christoph.berg@credativ.de, pgsql-bugs@lists.postgresql.org Date: Mon, 26 Jul 2021 12:54:22 +0000 Message-ID: <17123-734abc3934f500b6@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 --===============6666873362880587653== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzEyMwpMb2dnZWQgYnk6ICAgICAgICAgIENocmlzdG9waCBCZXJnCkVt YWlsIGFkZHJlc3M6ICAgICAgY2hyaXN0b3BoLmJlcmdAY3JlZGF0aXYuZGUKUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxMC4xNgpPcGVyYXRpbmcgc3lzdGVtOiAgIEFueQpEZXNjcmlwdGlvbjogICAgICAg IAoKUmVtb3ZpbmcgdGhlIGxhc3Qvb25seSBpbmhlcml0YW5jZSBjaGlsZCBmcm9tIGEgdGFibGUg dXNpbmcgQUxURVIgVEFCTEUgTk8KSU5IRVJJVCBsZWF2ZXMgb3JwaGFuZWQgc3RhdGlzdGljcyBi ZWhpbmQgdGhhdCBBTkFMWVpFIGRvZXNuJ3QgcmVtb3ZlLgpPcmlnaW5hbCBjdXN0b21lciBjb21w bGFpbnQgb24gMTAuMTYsIGJ1dCAxNWRldmVsIGhhcyB0aGUgc2FtZSBpc3N1ZS4NCg0KcHNxbCAt ZWYgaW5oZXJpdC5zcWwgDQpjcmVhdGUgdGFibGUgbG9nICh0cyB0aW1lc3RhbXB0eiwgZGF0YSB0 ZXh0KTsNCkNSRUFURSBUQUJMRQ0KWmVpdDogMiwzNzggbXMNCmluc2VydCBpbnRvIGxvZyB2YWx1 ZXMgKCcyMDIxLTA3LTAxJywgJzEnKTsNCklOU0VSVCAwIDENClplaXQ6IDAsNDU3IG1zDQppbnNl cnQgaW50byBsb2cgdmFsdWVzICgnMjAyMS0wOC0wMScsICcyJyk7DQpJTlNFUlQgMCAxDQpaZWl0 OiAwLDE5NyBtcw0KY3JlYXRlIHRhYmxlIGxvZzIgKGxpa2UgbG9nKSBpbmhlcml0cyAobG9nKTsN CnBzcWw6aW5oZXJpdC5zcWw6NDogSElOV0VJUzogIDAwMDAwOiBTcGFsdGUgwrt0c8KrIHdpcmQg bWl0IGdlZXJidGVyCkRlZmluaXRpb24genVzYW1tZW5nZWbDvGhydA0KT1JUOiAgTWVyZ2VBdHRy aWJ1dGVzLCB0YWJsZWNtZHMuYzoyODM3DQpwc3FsOmluaGVyaXQuc3FsOjQ6IEhJTldFSVM6ICAw MDAwMDogU3BhbHRlIMK7ZGF0YcKrIHdpcmQgbWl0IGdlZXJidGVyCkRlZmluaXRpb24genVzYW1t ZW5nZWbDvGhydA0KT1JUOiAgTWVyZ2VBdHRyaWJ1dGVzLCB0YWJsZWNtZHMuYzoyODM3DQpDUkVB VEUgVEFCTEUNClplaXQ6IDEsMzk2IG1zDQppbnNlcnQgaW50byBsb2cyIHZhbHVlcyAoJzIwMjEt MDEtMDEnLCAnMycpOw0KSU5TRVJUIDAgMQ0KWmVpdDogMCwzNTEgbXMNCmluc2VydCBpbnRvIGxv ZzIgdmFsdWVzICgnMjAyMS0wMi0wMScsICc0Jyk7DQpJTlNFUlQgMCAxDQpaZWl0OiAwLDE3NCBt cw0KYW5hbHl6ZSBsb2c7DQpBTkFMWVpFDQpaZWl0OiAxLDA5MyBtcw0Kc2VsZWN0ICogZnJvbSBw Z19zdGF0cyB3aGVyZSB0YWJsZW5hbWUgPSAnbG9nJyBhbmQgYXR0bmFtZSA9ICd0cycgDQrilIBb IFJFQ09SRCAxCl3ilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilKzilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIANCnNjaGVtYW5hbWUgICAgICAgICAgICAg4pSCIHB1YmxpYw0KdGFibGVuYW1lICAg ICAgICAgICAgICDilIIgbG9nDQphdHRuYW1lICAgICAgICAgICAgICAgIOKUgiB0cw0KaW5oZXJp dGVkICAgICAgICAgICAgICDilIIgZg0KbnVsbF9mcmFjICAgICAgICAgICAgICDilIIgMA0KYXZn X3dpZHRoICAgICAgICAgICAgICDilIIgOA0Kbl9kaXN0aW5jdCAgICAgICAgICAgICDilIIgLTEN Cm1vc3RfY29tbW9uX3ZhbHMgICAgICAg4pSCIOKIhQ0KbW9zdF9jb21tb25fZnJlcXMgICAgICDi lIIg4oiFDQpoaXN0b2dyYW1fYm91bmRzICAgICAgIOKUgiB7IjIwMjEtMDctMDEgMDA6MDA6MDAr MDIiLCIyMDIxLTA4LTAxCjAwOjAwOjAwKzAyIn0NCmNvcnJlbGF0aW9uICAgICAgICAgICAg4pSC IDENCm1vc3RfY29tbW9uX2VsZW1zICAgICAg4pSCIOKIhQ0KbW9zdF9jb21tb25fZWxlbV9mcmVx cyDilIIg4oiFDQplbGVtX2NvdW50X2hpc3RvZ3JhbSAgIOKUgiDiiIUNCuKUgFsgUkVDT1JEIDIK XeKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgA0K c2NoZW1hbmFtZSAgICAgICAgICAgICDilIIgcHVibGljDQp0YWJsZW5hbWUgICAgICAgICAgICAg IOKUgiBsb2cNCmF0dG5hbWUgICAgICAgICAgICAgICAg4pSCIHRzDQppbmhlcml0ZWQgICAgICAg ICAgICAgIOKUgiB0DQpudWxsX2ZyYWMgICAgICAgICAgICAgIOKUgiAwDQphdmdfd2lkdGggICAg ICAgICAgICAgIOKUgiA4DQpuX2Rpc3RpbmN0ICAgICAgICAgICAgIOKUgiAtMQ0KbW9zdF9jb21t b25fdmFscyAgICAgICDilIIg4oiFDQptb3N0X2NvbW1vbl9mcmVxcyAgICAgIOKUgiDiiIUNCmhp c3RvZ3JhbV9ib3VuZHMgICAgICAg4pSCIHsiMjAyMS0wMS0wMSAwMDowMDowMCswMSIsIjIwMjEt MDItMDEKMDA6MDA6MDArMDEiLCIyMDIxLTA3LTAxIDAwOjAwOjAwKzAyIiwiMjAyMS0wOC0wMSAw MDowMDowMCswMiJ9DQpjb3JyZWxhdGlvbiAgICAgICAgICAgIOKUgiAtMC42DQptb3N0X2NvbW1v bl9lbGVtcyAgICAgIOKUgiDiiIUNCm1vc3RfY29tbW9uX2VsZW1fZnJlcXMg4pSCIOKIhQ0KZWxl bV9jb3VudF9oaXN0b2dyYW0gICDilIIg4oiFDQoNClplaXQ6IDQsNjE2IG1zDQpzZWxlY3QgY3Rp ZCwgc3RhaW5oZXJpdCBmcm9tIHBnX3N0YXRpc3RpYyB3aGVyZSBzdGFyZWxpZCA9ICdsb2cnOjpy ZWdjbGFzcwphbmQgc3RhYXR0bnVtID0gMTsNCiAgY3RpZCAgIOKUgiBzdGFpbmhlcml0IA0K4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSADQogKDE4LDE3KSDilIIgZg0KICgxOCwxOSkg4pSCIHQNCigyIFplaWxlbikNCg0KWmVp dDogMCw4NTYgbXMNCmFsdGVyIHRhYmxlIGxvZzIgbm8gaW5oZXJpdCBsb2c7DQpBTFRFUiBUQUJM RQ0KWmVpdDogMCw0NDkgbXMNCmFuYWx5emUgbG9nOw0KQU5BTFlaRQ0KWmVpdDogMCwzOTQgbXMN CnNlbGVjdCAqIGZyb20gcGdfc3RhdHMgd2hlcmUgdGFibGVuYW1lID0gJ2xvZycgYW5kIGF0dG5h bWUgPSAndHMnIA0K4pSAWyBSRUNPUkQgMQpd4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSs4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSADQpzY2hlbWFuYW1lICAgICAgICAgICAgIOKUgiBwdWJs aWMNCnRhYmxlbmFtZSAgICAgICAgICAgICAg4pSCIGxvZw0KYXR0bmFtZSAgICAgICAgICAgICAg ICDilIIgdHMNCmluaGVyaXRlZCAgICAgICAgICAgICAg4pSCIGYNCm51bGxfZnJhYyAgICAgICAg ICAgICAg4pSCIDANCmF2Z193aWR0aCAgICAgICAgICAgICAg4pSCIDgNCm5fZGlzdGluY3QgICAg ICAgICAgICAg4pSCIC0xDQptb3N0X2NvbW1vbl92YWxzICAgICAgIOKUgiDiiIUNCm1vc3RfY29t bW9uX2ZyZXFzICAgICAg4pSCIOKIhQ0KaGlzdG9ncmFtX2JvdW5kcyAgICAgICDilIIgeyIyMDIx LTA3LTAxIDAwOjAwOjAwKzAyIiwiMjAyMS0wOC0wMQowMDowMDowMCswMiJ9DQpjb3JyZWxhdGlv biAgICAgICAgICAgIOKUgiAxDQptb3N0X2NvbW1vbl9lbGVtcyAgICAgIOKUgiDiiIUNCm1vc3Rf Y29tbW9uX2VsZW1fZnJlcXMg4pSCIOKIhQ0KZWxlbV9jb3VudF9oaXN0b2dyYW0gICDilIIg4oiF DQrilIBbIFJFQ09SRCAyCl3ilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIANCnNjaGVtYW5hbWUgICAgICAgICAgICAg4pSCIHB1YmxpYw0KdGFibGVu YW1lICAgICAgICAgICAgICDilIIgbG9nDQphdHRuYW1lICAgICAgICAgICAgICAgIOKUgiB0cw0K aW5oZXJpdGVkICAgICAgICAgICAgICDilIIgdCAgICAgICAgICA8LS0gbm90IHJlbW92ZWQNCm51 bGxfZnJhYyAgICAgICAgICAgICAg4pSCIDANCmF2Z193aWR0aCAgICAgICAgICAgICAg4pSCIDgN Cm5fZGlzdGluY3QgICAgICAgICAgICAg4pSCIC0xDQptb3N0X2NvbW1vbl92YWxzICAgICAgIOKU giDiiIUNCm1vc3RfY29tbW9uX2ZyZXFzICAgICAg4pSCIOKIhQ0KaGlzdG9ncmFtX2JvdW5kcyAg ICAgICDilIIgeyIyMDIxLTAxLTAxIDAwOjAwOjAwKzAxIiwiMjAyMS0wMi0wMQowMDowMDowMCsw MSIsIjIwMjEtMDctMDEgMDA6MDA6MDArMDIiLCIyMDIxLTA4LTAxIDAwOjAwOjAwKzAyIn0NCmNv cnJlbGF0aW9uICAgICAgICAgICAg4pSCIC0wLjYNCm1vc3RfY29tbW9uX2VsZW1zICAgICAg4pSC IOKIhQ0KbW9zdF9jb21tb25fZWxlbV9mcmVxcyDilIIg4oiFDQplbGVtX2NvdW50X2hpc3RvZ3Jh bSAgIOKUgiDiiIUNCg0KWmVpdDogMSw1MjYgbXMNCnNlbGVjdCBjdGlkLCBzdGFpbmhlcml0IGZy b20gcGdfc3RhdGlzdGljIHdoZXJlIHN0YXJlbGlkID0gJ2xvZyc6OnJlZ2NsYXNzCmFuZCBzdGFh dHRudW0gPSAxOw0KICBjdGlkICAg4pSCIHN0YWluaGVyaXQgDQrilIDilIDilIDilIDilIDilIDi lIDilIDilIDilLzilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIANCiAoMTgsMjEp IOKUgiBmDQogKDE4LDE5KSDilIIgdCAgICAgICAgICAgICA8LS0gbm90IHRvdWNoZWQNCigyIFpl aWxlbikNCg0KWmVpdDogMCwzNzMgbXMNCg0KY2F0IGluaGVyaXQuc3FsDQpjcmVhdGUgdGFibGUg bG9nICh0cyB0aW1lc3RhbXB0eiwgZGF0YSB0ZXh0KTsNCmluc2VydCBpbnRvIGxvZyB2YWx1ZXMg KCcyMDIxLTA3LTAxJywgJzEnKTsNCmluc2VydCBpbnRvIGxvZyB2YWx1ZXMgKCcyMDIxLTA4LTAx JywgJzInKTsNCmNyZWF0ZSB0YWJsZSBsb2cyIChsaWtlIGxvZykgaW5oZXJpdHMgKGxvZyk7DQpp bnNlcnQgaW50byBsb2cyIHZhbHVlcyAoJzIwMjEtMDEtMDEnLCAnMycpOw0KaW5zZXJ0IGludG8g bG9nMiB2YWx1ZXMgKCcyMDIxLTAyLTAxJywgJzQnKTsNCg0KYW5hbHl6ZSBsb2c7DQpzZWxlY3Qg KiBmcm9tIHBnX3N0YXRzIHdoZXJlIHRhYmxlbmFtZSA9ICdsb2cnIGFuZCBhdHRuYW1lID0gJ3Rz JyBcZ3gNCnNlbGVjdCBjdGlkLCBzdGFpbmhlcml0IGZyb20gcGdfc3RhdGlzdGljIHdoZXJlIHN0 YXJlbGlkID0gJ2xvZyc6OnJlZ2NsYXNzCmFuZCBzdGFhdHRudW0gPSAxOw0KDQphbHRlciB0YWJs ZSBsb2cyIG5vIGluaGVyaXQgbG9nOw0KDQphbmFseXplIGxvZzsNCnNlbGVjdCAqIGZyb20gcGdf c3RhdHMgd2hlcmUgdGFibGVuYW1lID0gJ2xvZycgYW5kIGF0dG5hbWUgPSAndHMnIFxneA0Kc2Vs ZWN0IGN0aWQsIHN0YWluaGVyaXQgZnJvbSBwZ19zdGF0aXN0aWMgd2hlcmUgc3RhcmVsaWQgPSAn bG9nJzo6cmVnY2xhc3MKYW5kIHN0YWF0dG51bSA9IDE7Cgo= --===============6666873362880587653==--