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 1l4cgp-000620-J2 for pgsql-docs@arkaria.postgresql.org; Wed, 27 Jan 2021 04:44:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l4cgo-0001M8-FE for pgsql-docs@arkaria.postgresql.org; Wed, 27 Jan 2021 04:44:22 +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 1l4cgn-0001M0-3h for pgsql-docs@lists.postgresql.org; Wed, 27 Jan 2021 04:44:22 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l4cgk-0004Wr-5f for pgsql-docs@lists.postgresql.org; Wed, 27 Jan 2021 04:44:20 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id D1CEC5C013F; Tue, 26 Jan 2021 23:44:16 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Tue, 26 Jan 2021 23:44:16 -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=zCFytpWJXZYNJ0JozMFClwwPirV Vn+k7zD8Mvj8RLCc=; b=R7AzfBqLryiCl8cDmct5KWkz+MQv/f7QoR8WaOGf7bs BRuvhtYJWVnzcQjiFmPox7MROGn0rfs/zMzYOA3nrGf9PqzTXtYIH3Zhr05LI80F iuDokw7NF8RWPza3ReYogzX54XI8zH6ERa17nkIY3KqOsEpJ4FWhlvvUjJvBTHeE WKmY98+CMkGK0G+U5yLSdqA6P6LyKMhuZQm3rLPAy3Is5bHiPd591RJs38JKl1eh op6yVuCGDhDCLAKK9bj5lmqzPuCa6yLC6LFbvlcNg0MyV5jYr2zYUcWh60ZQIh1k PWWcV/mQG/kSf4b3XyrI5rCZ0STOWxW7mgPMmA/amJw== 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=zCFytp WJXZYNJ0JozMFClwwPirVVn+k7zD8Mvj8RLCc=; b=MyAiVOlTgO5N17XvDTWJUl pbz0YWx5xM42y+R+aYk9if+kWReZdxC5v6gd+mBr5MaBSRM7ZZ812lZvscTa3T5R TqzzvljfElJK0M1zfA/hwfCXiljO1xOXoiAkCgsBUs9vgK4m9+QSv3ZC+AAJiQdO V1chM4v+KR0yBXvldLV0pU/zUW7tNOzLCjKGq7EjJzCXvqIC7FaJIgf/vo5d0L3z cFKZjOQjrTx0QetzdyaG3YR/PTfHvp1GHsRY+AivjdL0sKz1rVRm20u8gVwtmK43 bW3od1sah0C6ByVXeRdcOMzcC1kNcPiVdpYZGC7ZUebpqLnOCcFo9yjIMl4qUxYQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrvdejgdejhecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdefhedmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepffdufeeflefghfekudekkeevvddu gfeiteekkeduleefvefhhffftdduffeiuedtnecuffhomhgrihhnpehpohhsthhgrhgvsh hqlhdrohhrghenucfkphepudduuddruddtvddrudektddrudekheenucevlhhushhtvghr ufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquh hivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id AD23C108005F; Tue, 26 Jan 2021 23:44:14 -0500 (EST) Date: Wed, 27 Jan 2021 13:44:11 +0900 From: Michael Paquier To: harisai hari Cc: Laurenz Albe , pgsql-docs@lists.postgresql.org Subject: Re: TRUNCATE VIEW Message-ID: References: <161157636877.14625.15340884663716426087@wrigleys.postgresql.org> <4d8ee45bb0d07a09da5d64d6cba114e7db5777b3.camel@cybertec.at> <56514982026dea49ebb6ee33fab28e13daa9b6f5.camel@cybertec.at> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="pvuL4QOa05Y3Vv6g" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --pvuL4QOa05Y3Vv6g Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Jan 26, 2021 at 09:54:48AM +0900, Michael Paquier wrote: > Yes, this page is wrong to tell that. This one has been fixed with 32bef75 down to 12. > There is a second thing that I find confusing in the docs of > TRUNCATE: > https://www.postgresql.org/docs/devel/sql-truncate.html > > This does not mention at all partitioned tables, describing only > "descendant tables". Partitioning is a case of "descendant tables" > but that's a bit confusing IMO and a reader would need to guess that. Not sure what to do about this part yet. -- Michael --pvuL4QOa05Y3Vv6g Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmAQ75sACgkQnvQgOdby QH3pOw/9HCB095OxSSIdPKr2Ypf6N1qiafwD1mvoDByhCmgWbK2NYfh6AqH55xc2 vI0M1OcTtHrMAia2145qKFDCXgysSy8+JcbJtLqcQ3kLmUUCZ22BMcH6IwUItg5v faZCUtAvEopUsm44tx6Gt4ZUU7z5+TK9LPkImqfcnG788z/MCci4CQHQU64lKVVu wOuuBmTmBEKMjHH3a6kmwEnn7o2QQQwq6hdlNmGT/NID3pdoslMzp8N4IXDD8H3p O39wt1eY/JgiD7oTwtj66/aZqXufmCHSpLbhjZkKBdYVsxkMg2FtYUFdgp+ig2Fp suf5ocmM6rwy/W64VDdjXuqC/K62aKgF5qutbdgUXGs8rr4oAOaBqNE/iUXjvdHV i7fOG+aUSDbAllz3D2a/b4JWenPJqGO318oCQGouz5oe3ZNYackPPzLV55xDsXO2 90jNh/WCbkr+FF53nDWgTy4AXJnvhr2pf3faedKB7yPWdHappMklznOCcp0wfmue iD3pbfP2FnHCE1M3oi+Wf9Los0rcOmrvopC4uNO7zb7ydDCGIFDSqbrrKriH0LTB 9NB3G6lZWVc73exNNUYBhb1jh+L+ZImqZ7VNLEJ/djsit2UY4qDL1pANx+qscD/p 9yj/0w6L3f/2wbEPnrQExcNPlLGr+7qJ9F1tjF2TgxKCTrIoHjk= =ALlI -----END PGP SIGNATURE----- --pvuL4QOa05Y3Vv6g--