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 1gc2ey-0005aG-Fk for pgsql-bugs@arkaria.postgresql.org; Wed, 26 Dec 2018 06:27:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gc2ex-0007jH-2o for pgsql-bugs@arkaria.postgresql.org; Wed, 26 Dec 2018 06:27:15 +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 1gc2ew-0007j6-PB for pgsql-bugs@lists.postgresql.org; Wed, 26 Dec 2018 06:27:14 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gc2es-0004EI-R9 for pgsql-bugs@lists.postgresql.org; Wed, 26 Dec 2018 06:27:13 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 16AB121BE2; Wed, 26 Dec 2018 01:27:10 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 26 Dec 2018 01:27:10 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=NmxD8xyr7ZCjPl0RLiCPOH2DvdM PK+RT2ok3h+D04SA=; b=CeFmQz440dJyj9ch2o5mcwTaz9hjJRCzs1BaN2ZT+S9 rQ9Dx7dWTwVnhRikzteVip7V8pyg9LKxCUPbt/52VN4cBj6bIMiaxhOOFGON7fKn txE9vLcvgwBYV+JcTEokYr3SoxhzfH7zUESYmVb8fNFDEdKYbhaSKCRrelhu7Foh Sg8ZEVWwzdl1PdAQw0YKZiFLuI/z1uYUulkC2Pg3bVFEk9DHv2kH6hC3LEb2FZgM QA7/IMl9qi8aYwDslXKBtaxd0woQD5jrY1lIT6jto8Xr9X/bUh/7CGi1OET3W6Ub cljSpEg1Nyd1F8BkoVPIZZc70Xa7sI8K8lR2/8vMbYQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=NmxD8x yr7ZCjPl0RLiCPOH2DvdMPK+RT2ok3h+D04SA=; b=iZzfYR/owx9UK9Qq82fE7w +AzDZs7PHdJydSmwBSQ6Ej6sK8cIw7vqBB/5T1gUSR0psNQzPBX7UerWf0f6d+jC npD7G8P05VGRKjwJTOG87ta3lkp24PEbIkj90GSl1Ay40Pd1GGPqHgCJPmqSMx6G tbHeMykxI2ycNtB0eBSFDb5JJRxqeSivoV/xmr+xpwAy8DmOWFtt9ctu33F8M73m 5aQmJ3NVH0YdvY+wgf/GLJIyRjfwkbhI6rwNZO1loThcaB4ZTbQhy8dAjh6HekqH 94wOjcvsf8kKT51lvzvlqJZNv0jwiTwiWXYapU50/++/i0kkHnHCh2qklvPeh+TQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtkedrudekgedgleejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfquhhtnecuuegrihhlohhuthemucef tddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlhcuvffnffculdefhe dmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttdejnecuhfhrohhmpefoihgt hhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqne cuffhomhgrihhnpehgihhthhhusgdrtghomhenucfkphepuddukedrvdeguddrvdehtddr vdegjeenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrh drgiihiienucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (mp76f1faf7.ap.nuro.jp [118.241.250.247]) by mail.messagingengine.com (Postfix) with ESMTPA id E39C0100BA; Wed, 26 Dec 2018 01:27:06 -0500 (EST) Date: Wed, 26 Dec 2018 15:27:03 +0900 From: Michael Paquier To: =?utf-8?B?5b635ZOl?= 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 Message-ID: <20181226062703.GM2234@paquier.xyz> References: <15565-ce67a48d0244436a@postgresql.org> <0285c6d1-2d11-2f2c-6fae-d4575cdc3c7b@lab.ntt.co.jp> <20181225080314.GF2334@paquier.xyz> <20181226015127.GB2234@paquier.xyz> <3466d6bc.57f7.167e91f000e.Coremail.digoal@126.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="51uid+Ur/3ko9cBW" Content-Disposition: inline In-Reply-To: <3466d6bc.57f7.167e91f000e.Coremail.digoal@126.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --51uid+Ur/3ko9cBW Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Dec 26, 2018 at 02:06:22PM +0800, =E5=BE=B7=E5=93=A5 wrote: > We can use this feature emulate Oracle-style Global temp table. > https://github.com/digoal/blog/blob/master/201807/20180715_01.md I am not sure what's the point you are trying to make here regarding to this bug. Anyway, it would be a good idea to put the important quotes you would like folks here to know about, so as if github.com goes away the archives of Postgres are still aware of what you are trying to explain without an external source... -- Michael --51uid+Ur/3ko9cBW Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIyBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlwjHzcACgkQnvQgOdby QH0qMQ/492E3Qy18Dl5iw/Z/WHNLMvF1ZKtbU5sHjox5HLvUHoM4lDUdY6qk3bMX y0rAxgyP4oM7DAG5V6qjhyVq5Aj2xU4/SWlhhyH4b973gQ3Z7HxZTrLlwQtyGBFL X89x4Ttpxmhs3Dh6w56WeAo3SEHq+ioUFsdEaSotIF4LlXBUpjsPAUBH7mO8xTYC RV5dZFW9KQ7iN9t70b7DUDSq2/CKI52lUriALkSDSzF9mn7VXlWNje9tU+7JoSu7 QoSQsJ160iodbBmQj960uc2wY1HXtCEKDIKA3s3JIxWHdVpmvQ3LsE9ELF+S47OZ BuSU1CUzbZeZHwOkXRN9FOKMhD0G8ZcDWLrVYpVu+kI6cQuzdvrHyO73k319t19C ZSwgLfdjhR5aWPtJPapmE3cXSp1bOl5puMss+FxQmpZW98qrJhTVWfu5cToPCJiP d+lh/HiVsmJWybYHfR95v2x8ntm+xULMs9mK9PQvutEXpRcEBgQT2e0Mr5ngGE9j eNrdJcjk8Gg+I6U6cXQukAuDJvhBoYR1lsXsMiWrecYHACGKhokwCP1xOMCmxioM l+ZFCJJtBGzvcAip3upDHLvrc8eyVIn630kTjk18u9+fg4WpfCjBVdrQgROfOPcD g/GP8z7vgwdqfgFOEsAROC3TQoSl/dNkfmh6Zlwr0gFCZ9J2Tw== =s9zO -----END PGP SIGNATURE----- --51uid+Ur/3ko9cBW--