Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gc2Mk-0004Si-VF for pgsql-bugs@arkaria.postgresql.org; Wed, 26 Dec 2018 06:08:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gc2Mj-0003H4-Kw for pgsql-bugs@arkaria.postgresql.org; Wed, 26 Dec 2018 06:08:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gc2Mi-0003Ax-MI for pgsql-bugs@lists.postgresql.org; Wed, 26 Dec 2018 06:08:25 +0000 Received: from m15-9.126.com ([220.181.15.9]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gc2Mb-0003lN-7U for pgsql-bugs@lists.postgresql.org; Wed, 26 Dec 2018 06:08:23 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:Subject:MIME-Version:Message-ID; bh=GcyNk 1DVVxVRNVkgpXT/qe8JdnOp8PF44rcaUHRLqIU=; b=WRiogKilWmsTecc0ltnwI ajpw34Z+as9CGxRAV/KVGthYnphS9yPRYax1G2LbK7CpFRIAB6eCVMa0jSodsWbw f5p961JqirNNEKfTLzgY1t8QuD7uvMz6hP/TFiIxyAyv0FRlJtEbPak5/nF47LsI VBOSQrFoDST50IjslnShTQ= Received: from digoal$126.com ( [42.120.75.137] ) by ajax-webmail-wmsvr9 (Coremail) ; Wed, 26 Dec 2018 14:06:22 +0800 (CST) X-Originating-IP: [42.120.75.137] Date: Wed, 26 Dec 2018 14:06:22 +0800 (CST) From: =?GBK?B?tcK45w==?= To: "Michael Paquier" Cc: "Amit Langote" , "David Rowley" , pgsql-bugs@lists.postgresql.org, "PG Bug reporting form" Subject: Re:Re: BUG #15565: truncate bug with tables which have temp table inherited X-Priority: 3 X-Mailer: Coremail Webmail Server Version SP_ntes V3.5 build 20180927(cd7136b6) Copyright (c) 2002-2018 www.mailtech.cn 126com In-Reply-To: <20181226015127.GB2234@paquier.xyz> References: <15565-ce67a48d0244436a@postgresql.org> <0285c6d1-2d11-2f2c-6fae-d4575cdc3c7b@lab.ntt.co.jp> <20181225080314.GF2334@paquier.xyz> <20181226015127.GB2234@paquier.xyz> Content-Type: multipart/alternative; boundary="----=_Part_83842_890690666.1545804382222" MIME-Version: 1.0 Message-ID: <3466d6bc.57f7.167e91f000e.Coremail.digoal@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: CcqowACnrzxfGiNcDuuzAQ--.25547W X-CM-SenderInfo: 5glj0tbo6rjloofrz/1tbi4g4pl1pD674QNwABs4 X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_83842_890690666.1545804382222 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 VGhhbmtzLCAKV2UgY2FuIHVzZSB0aGlzIGZlYXR1cmUgZW11bGF0ZSBPcmFjbGUtc3R5bGUgR2xv YmFsIHRlbXAgdGFibGUuCmh0dHBzOi8vZ2l0aHViLmNvbS9kaWdvYWwvYmxvZy9ibG9iL21hc3Rl ci8yMDE4MDcvMjAxODA3MTVfMDEubWQgICAKCgpiZXN0IHJlZ2FyZHMsCmRpZ29hbAoKCgoKLS0K uavS5srH0ruxstfTtcTKwixJJ20gRGlnb2FsLEp1c3QgRG8gSXQuCgoKCgpBdCAyMDE4LTEyLTI2 IDA5OjUxOjI3LCAiTWljaGFlbCBQYXF1aWVyIiA8bWljaGFlbEBwYXF1aWVyLnh5ej4gd3JvdGU6 Cj5PbiBUdWUsIERlYyAyNSwgMjAxOCBhdCAwNTo0NjoyOFBNICswOTAwLCBBbWl0IExhbmdvdGUg d3JvdGU6Cj4+IE9uIDIwMTgvMTIvMjUgMTc6MDMsIE1pY2hhZWwgUGFxdWllciB3cm90ZToKPj4+ IE5vcGUsIGl0IGRvZXNuJ3QuICBoZWFwX2Nsb3NlIG91Z2h0IHRvIG5vdCBub3JtYWxseSByZWxl YXNlIHRoZSBsb2NrCj4+PiBlaXRoZXIgdW50aWwgdGhlIHRyYW5zYWN0aW9uIGhhcyBjb21taXR0 ZWQuCj4+IAo+PiBOb3RlIHRoYXQgZXhwYW5kX2luaGVyaXRlZF9ydGVudHJ5IGRvZXMgcmVsZWFz ZSB0aGUgbG9jay4KPj4gCj4+ICAgICAgICAgLyoKPj4gICAgICAgICAgKiBJdCBpcyBwb3NzaWJs ZSB0aGF0IHRoZSBwYXJlbnQgdGFibGUgaGFzIGNoaWxkcmVuIHRoYXQgYXJlIHRlbXAKPj4gICAg ICAgICAgKiB0YWJsZXMgb2Ygb3RoZXIgYmFja2VuZHMuICBXZSBjYW5ub3Qgc2FmZWx5IGFjY2Vz cyBzdWNoIHRhYmxlcwo+PiAgICAgICAgICAqIChiZWNhdXNlIG9mIGJ1ZmZlcmluZyBpc3N1ZXMp LCBhbmQgdGhlIGJlc3QgdGhpbmcgdG8gZG8gc2VlbXMKPj4gICAgICAgICAgKiB0byBiZSB0byBz aWxlbnRseSBpZ25vcmUgdGhlbS4KPj4gICAgICAgICAgKi8KPj4gICAgICAgICBpZiAoY2hpbGRP SUQgIT0gcGFyZW50T0lEICYmIFJFTEFUSU9OX0lTX09USEVSX1RFTVAobmV3cmVsYXRpb24pKQo+ PiAgICAgICAgIHsKPj4gICAgICAgICAgICAgaGVhcF9jbG9zZShuZXdyZWxhdGlvbiwgbG9ja21v ZGUpOwo+PiAgICAgICAgICAgICBjb250aW51ZTsKPj4gICAgICAgICB9Cj4KPk9oLCBnb29kIHBv aW50IGhlcmUuICBCb3RoIERhdmlkIGFuZCB5b3UgaGF2ZSBiZWVuIHRvdWNoaW5nIHRoaXMgYXJl YQo+b2YgdGhlIGNvZGUgd2F5IG1vcmUgdGhhbiBteXNlbGYgbGF0ZWx5Lgo+Cj4+PiBUaGUgcGF0 Y2ggY2xvYmJlcnMKPj4+IHNvbWV0aGluZyB0aGF0IHRydW5jYXRlX2NoZWNrX2FjdGl2aXR5KCkg YWxyZWFkeSBjaGVja3MsIHdoaWNoIGlzIG5vdAo+Pj4gZWxlZ2FudC4KPj4gCj4+IEluZGVlZCwg SSBtaXNzZWQgdHJ1bmNhdGVfY2hlY2tfYWN0aXZpdHkuICBBbHRob3VnaCwgaWYgd2Ugd2FudCB0 byBmaXgKPj4gdGhpcyBiZWhhdmlvciBsaWtlIEknbSBwcm9wb3NpbmcgKGlnbm9yZSBjaGlsZCB0 YWJsZXMgdGhhdCBhcmUgdGVtcG9yYXJ5Cj4+IHRhYmxlcyBvZiBvdGhlciBzZXNzaW9ucyksIGl0 IG1heSBub3QgYmUgc3VjaCBhIGdvb2QgaWRlYSB0byBkbyBpdCBieQo+PiBtb2RpZnlpbmcgdHJ1 bmNhdGVfY2hlY2tfYWN0aXZpdHkgdG8gZGVhbCBzcGVjaWFsbHkgd2l0aCBzdWNoIHRhYmxlcywK Pj4gYmVjYXVzZSB0aGF0IHdvdWxkIHVubmVjZXNzYXJpbHkgY29tcGxpY2F0ZSBpdHMgaW50ZXJm YWNlLgo+Cj5JIGdvdCB0byB0aGluayBtb3JlIGFib3V0IHRoYXQgcG9pbnQsIGFuZCBpbmRlZWQg SSBhZ3JlZSB3aXRoIHlvdXIKPnBvaW50IHRvIGNvbXBsaWNhdGUgdHJ1bmNhdGVfY2hlY2tfYWN0 aXZpdHkgbW9yZSB0aGFuIG5lY2Vzc2FyeSBhcyBpdAo+c3RpbGwgZ2V0cyB1c2VkIGZvciBDQVND QURFIGFuZCBwYXJlbnQgcmVsYXRpb25zLCBzbyB3aGF0IHlvdSBhcmUKPnByb3Bvc2luZyBpcyBh Y2NlcHRhYmxlIHRvIG1lLgo+Cj4+PiBJIGFtIHdvbmRlcmluZyBhcyB3ZWxsIGlmIHdlIGNvdWxk IHRha2UgdGhpcyBvY2Nhc2lvbiBmb3IKPj4+IGhhdmluZyBiZXR0ZXIgaXNvbGF0aW9uIHRlc3Rp bmcgd2hlbiBpdCBjb21lcyB0byBpbmhlcml0YW5jZSB0cmVlcwo+Pj4gbWl4aW5nIHJlbGF0aW9u IHBlcnNpc3RlbmN5LiAgQXQgbGVhc3QgZm9yIHRoZSBUUlVOQ0FURSBjYXNlIGl0IHdvdWxkCj4+ PiBiZSBuaWNlIHRvIGhhdmUgc29tZXRoaW5nLgo+PiAKPj4gWWVhaCwgcGVyaGFwcy4KPgo+TGV0 J3MgYml0ZSB0aGUgYnVsbGV0IHRoZW4uICBBdHRhY2hlZCBpcyBhIG1vcmUgYWR2YW5jZWQgcGF0 Y2ggd2hpY2gKPmlzIGJhc2VkIG9uIHdoYXQgeW91IHByZXZpb3VzbHkgc2VudCwgZXhjZXB0IHRo YXQgSSBkb24ndCBsaWtlIG11Y2gKPnRoZSBmYWN0IG9mIGNvcHlpbmcgQWNjZXNzRXhjbHVzaXZl TG9jayBhcm91bmQsIHNvIGxldCdzIHNhdmUgaXQgaW50bwo+YSBzZXBhcmF0ZSB2YXJpYWJsZS4g IEkgaG9wZSB0aGF0J3MgY2xlYXJlci4gIEkgaGF2ZSBhbHNvIGRlc2lnbmVkIGEKPnNldCBvZiBp c29sYXRpb24gdGVzdHMgd2hpY2ggYWRkcyBtb3JlIGNvdmVyYWdlIGZvciBpbmhlcml0YW5jZSB0 cmVlcwo+bWl4aW5nIHBlcnNpc3RlbmNlIGFjcm9zcyBzZXNzaW9ucyB3aGljaCBJIGFsc28gdXNl ZCB0byBjaGVjayB0aGUKPnBhdGNoLiAgVGhpcyB0ZXN0IHN1aXRlIGNvdWxkIGFsd2F5cyBiZSBl eHBhbmRlZCBsYXRlciBvbiwgYnV0IEkgdGhpbmsKPnRoYXQncyBhbHJlYWR5IGEgc3RlcCBpbiB0 aGUgZ29vZCBkaXJlY3Rpb24uCj4KPlRob3VnaHRzPwo+LS0KPk1pY2hhZWwK ------=_Part_83842_890690666.1545804382222 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXY+VGhhbmtzLCZuYnNwOzwvZGl2PjxkaXY+V2UgY2FuIHVz ZSB0aGlzIGZlYXR1cmUgZW11bGF0ZSBPcmFjbGUtc3R5bGUgR2xvYmFsIHRlbXAgdGFibGUuPC9k aXY+PGRpdj48YSBocmVmPSJodHRwczovL2dpdGh1Yi5jb20vZGlnb2FsL2Jsb2cvYmxvYi9tYXN0 ZXIvMjAxODA3LzIwMTgwNzE1XzAxLm1kIiBfc3JjPSJodHRwczovL2dpdGh1Yi5jb20vZGlnb2Fs L2Jsb2cvYmxvYi9tYXN0ZXIvMjAxODA3LzIwMTgwNzE1XzAxLm1kIj5odHRwczovL2dpdGh1Yi5j b20vZGlnb2FsL2Jsb2cvYmxvYi9tYXN0ZXIvMjAxODA3LzIwMTgwNzE1XzAxLm1kPC9hPiZuYnNw OyAmbmJzcDs8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PmJlc3QgcmVnYXJkcyw8L2Rpdj48ZGl2 PmRpZ29hbDwvZGl2Pjxicj48YnI+PGJyPjxkaXYgc3R5bGU9InBvc2l0aW9uOnJlbGF0aXZlO3pv b206MSI+LS08YnI+uavS5srH0ruxstfTtcTKwixJJ20gRGlnb2FsLEp1c3QgRG8gSXQuPGJyPjxk aXYgc3R5bGU9ImNsZWFyOmJvdGgiPjwvZGl2PjwvZGl2PjxkaXYgaWQ9ImRpdk5ldGVhc2VNYWls Q2FyZCI+PC9kaXY+PGJyPjxwcmU+PGJyPkF0IDIwMTgtMTItMjYgMDk6NTE6MjcsICJNaWNoYWVs IFBhcXVpZXIiICZsdDttaWNoYWVsQHBhcXVpZXIueHl6Jmd0OyB3cm90ZToKJmd0O09uIFR1ZSwg RGVjIDI1LCAyMDE4IGF0IDA1OjQ2OjI4UE0gKzA5MDAsIEFtaXQgTGFuZ290ZSB3cm90ZToKJmd0 OyZndDsgT24gMjAxOC8xMi8yNSAxNzowMywgTWljaGFlbCBQYXF1aWVyIHdyb3RlOgomZ3Q7Jmd0 OyZndDsgTm9wZSwgaXQgZG9lc24ndC4gIGhlYXBfY2xvc2Ugb3VnaHQgdG8gbm90IG5vcm1hbGx5 IHJlbGVhc2UgdGhlIGxvY2sKJmd0OyZndDsmZ3Q7IGVpdGhlciB1bnRpbCB0aGUgdHJhbnNhY3Rp b24gaGFzIGNvbW1pdHRlZC4KJmd0OyZndDsgCiZndDsmZ3Q7IE5vdGUgdGhhdCBleHBhbmRfaW5o ZXJpdGVkX3J0ZW50cnkgZG9lcyByZWxlYXNlIHRoZSBsb2NrLgomZ3Q7Jmd0OyAKJmd0OyZndDsg ICAgICAgICAvKgomZ3Q7Jmd0OyAgICAgICAgICAqIEl0IGlzIHBvc3NpYmxlIHRoYXQgdGhlIHBh cmVudCB0YWJsZSBoYXMgY2hpbGRyZW4gdGhhdCBhcmUgdGVtcAomZ3Q7Jmd0OyAgICAgICAgICAq IHRhYmxlcyBvZiBvdGhlciBiYWNrZW5kcy4gIFdlIGNhbm5vdCBzYWZlbHkgYWNjZXNzIHN1Y2gg dGFibGVzCiZndDsmZ3Q7ICAgICAgICAgICogKGJlY2F1c2Ugb2YgYnVmZmVyaW5nIGlzc3Vlcyks IGFuZCB0aGUgYmVzdCB0aGluZyB0byBkbyBzZWVtcwomZ3Q7Jmd0OyAgICAgICAgICAqIHRvIGJl IHRvIHNpbGVudGx5IGlnbm9yZSB0aGVtLgomZ3Q7Jmd0OyAgICAgICAgICAqLwomZ3Q7Jmd0OyAg ICAgICAgIGlmIChjaGlsZE9JRCAhPSBwYXJlbnRPSUQgJmFtcDsmYW1wOyBSRUxBVElPTl9JU19P VEhFUl9URU1QKG5ld3JlbGF0aW9uKSkKJmd0OyZndDsgICAgICAgICB7CiZndDsmZ3Q7ICAgICAg ICAgICAgIGhlYXBfY2xvc2UobmV3cmVsYXRpb24sIGxvY2ttb2RlKTsKJmd0OyZndDsgICAgICAg ICAgICAgY29udGludWU7CiZndDsmZ3Q7ICAgICAgICAgfQomZ3Q7CiZndDtPaCwgZ29vZCBwb2lu dCBoZXJlLiAgQm90aCBEYXZpZCBhbmQgeW91IGhhdmUgYmVlbiB0b3VjaGluZyB0aGlzIGFyZWEK Jmd0O29mIHRoZSBjb2RlIHdheSBtb3JlIHRoYW4gbXlzZWxmIGxhdGVseS4KJmd0OwomZ3Q7Jmd0 OyZndDsgVGhlIHBhdGNoIGNsb2JiZXJzCiZndDsmZ3Q7Jmd0OyBzb21ldGhpbmcgdGhhdCB0cnVu Y2F0ZV9jaGVja19hY3Rpdml0eSgpIGFscmVhZHkgY2hlY2tzLCB3aGljaCBpcyBub3QKJmd0OyZn dDsmZ3Q7IGVsZWdhbnQuCiZndDsmZ3Q7IAomZ3Q7Jmd0OyBJbmRlZWQsIEkgbWlzc2VkIHRydW5j YXRlX2NoZWNrX2FjdGl2aXR5LiAgQWx0aG91Z2gsIGlmIHdlIHdhbnQgdG8gZml4CiZndDsmZ3Q7 IHRoaXMgYmVoYXZpb3IgbGlrZSBJJ20gcHJvcG9zaW5nIChpZ25vcmUgY2hpbGQgdGFibGVzIHRo YXQgYXJlIHRlbXBvcmFyeQomZ3Q7Jmd0OyB0YWJsZXMgb2Ygb3RoZXIgc2Vzc2lvbnMpLCBpdCBt YXkgbm90IGJlIHN1Y2ggYSBnb29kIGlkZWEgdG8gZG8gaXQgYnkKJmd0OyZndDsgbW9kaWZ5aW5n IHRydW5jYXRlX2NoZWNrX2FjdGl2aXR5IHRvIGRlYWwgc3BlY2lhbGx5IHdpdGggc3VjaCB0YWJs ZXMsCiZndDsmZ3Q7IGJlY2F1c2UgdGhhdCB3b3VsZCB1bm5lY2Vzc2FyaWx5IGNvbXBsaWNhdGUg aXRzIGludGVyZmFjZS4KJmd0OwomZ3Q7SSBnb3QgdG8gdGhpbmsgbW9yZSBhYm91dCB0aGF0IHBv aW50LCBhbmQgaW5kZWVkIEkgYWdyZWUgd2l0aCB5b3VyCiZndDtwb2ludCB0byBjb21wbGljYXRl IHRydW5jYXRlX2NoZWNrX2FjdGl2aXR5IG1vcmUgdGhhbiBuZWNlc3NhcnkgYXMgaXQKJmd0O3N0 aWxsIGdldHMgdXNlZCBmb3IgQ0FTQ0FERSBhbmQgcGFyZW50IHJlbGF0aW9ucywgc28gd2hhdCB5 b3UgYXJlCiZndDtwcm9wb3NpbmcgaXMgYWNjZXB0YWJsZSB0byBtZS4KJmd0OwomZ3Q7Jmd0OyZn dDsgSSBhbSB3b25kZXJpbmcgYXMgd2VsbCBpZiB3ZSBjb3VsZCB0YWtlIHRoaXMgb2NjYXNpb24g Zm9yCiZndDsmZ3Q7Jmd0OyBoYXZpbmcgYmV0dGVyIGlzb2xhdGlvbiB0ZXN0aW5nIHdoZW4gaXQg Y29tZXMgdG8gaW5oZXJpdGFuY2UgdHJlZXMKJmd0OyZndDsmZ3Q7IG1peGluZyByZWxhdGlvbiBw ZXJzaXN0ZW5jeS4gIEF0IGxlYXN0IGZvciB0aGUgVFJVTkNBVEUgY2FzZSBpdCB3b3VsZAomZ3Q7 Jmd0OyZndDsgYmUgbmljZSB0byBoYXZlIHNvbWV0aGluZy4KJmd0OyZndDsgCiZndDsmZ3Q7IFll YWgsIHBlcmhhcHMuCiZndDsKJmd0O0xldCdzIGJpdGUgdGhlIGJ1bGxldCB0aGVuLiAgQXR0YWNo ZWQgaXMgYSBtb3JlIGFkdmFuY2VkIHBhdGNoIHdoaWNoCiZndDtpcyBiYXNlZCBvbiB3aGF0IHlv dSBwcmV2aW91c2x5IHNlbnQsIGV4Y2VwdCB0aGF0IEkgZG9uJ3QgbGlrZSBtdWNoCiZndDt0aGUg ZmFjdCBvZiBjb3B5aW5nIEFjY2Vzc0V4Y2x1c2l2ZUxvY2sgYXJvdW5kLCBzbyBsZXQncyBzYXZl IGl0IGludG8KJmd0O2Egc2VwYXJhdGUgdmFyaWFibGUuICBJIGhvcGUgdGhhdCdzIGNsZWFyZXIu ICBJIGhhdmUgYWxzbyBkZXNpZ25lZCBhCiZndDtzZXQgb2YgaXNvbGF0aW9uIHRlc3RzIHdoaWNo IGFkZHMgbW9yZSBjb3ZlcmFnZSBmb3IgaW5oZXJpdGFuY2UgdHJlZXMKJmd0O21peGluZyBwZXJz aXN0ZW5jZSBhY3Jvc3Mgc2Vzc2lvbnMgd2hpY2ggSSBhbHNvIHVzZWQgdG8gY2hlY2sgdGhlCiZn dDtwYXRjaC4gIFRoaXMgdGVzdCBzdWl0ZSBjb3VsZCBhbHdheXMgYmUgZXhwYW5kZWQgbGF0ZXIg b24sIGJ1dCBJIHRoaW5rCiZndDt0aGF0J3MgYWxyZWFkeSBhIHN0ZXAgaW4gdGhlIGdvb2QgZGly ZWN0aW9uLgomZ3Q7CiZndDtUaG91Z2h0cz8KJmd0Oy0tCiZndDtNaWNoYWVsCjwvcHJlPjwvZGl2 Pg== ------=_Part_83842_890690666.1545804382222--