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 1l4CdM-0004nq-Fg for pgsql-docs@arkaria.postgresql.org; Tue, 26 Jan 2021 00:55:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l4CdJ-0002vW-9b for pgsql-docs@arkaria.postgresql.org; Tue, 26 Jan 2021 00:55:01 +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 1l4CdH-0002vN-PC for pgsql-docs@lists.postgresql.org; Tue, 26 Jan 2021 00:55:01 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l4CdD-0006SZ-Sm for pgsql-docs@lists.postgresql.org; Tue, 26 Jan 2021 00:54:58 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id E0ECC5C0161; Mon, 25 Jan 2021 19:54:52 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Mon, 25 Jan 2021 19:54:52 -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=JySrCyYjghEGGHKnYgMWC5cvcJx /+4nkS6kbQVv22kg=; b=uZAUhyP0Oca4+Du4LwKcqdCCeYrfVg00cmbIk30Ht0A uuAlnbx+BdM63RjQOPVd4fcsC3axptNCTTDragvoW+ti8l0+lJHkVRf6ILuGu5w3 T4HPAY9xd0anfqJvDx1s6jrNN4hFclMsgtQ86lOmUWhKF2IAWNabmBHVdknqZZNs D4ci3nRP9BPZhnqk6kO+83KnKv3PtCdEtd59jUfz1M//rgdTedjzoK/zwOvTZMEQ 19vxgtESBI5U29QGS/XtuOofYpOi4y4WYf3ea2DObVhAvwdBvtkqEHdArZBjHLgv mfXkdWFN4qKWTdz8sxXA9t1LYHWktMa25+VmQpOeFeA== 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=JySrCy YjghEGGHKnYgMWC5cvcJx/+4nkS6kbQVv22kg=; b=RnqThPDYvlmrcd+rPu8PIH gjvqZOlu6uKEY26UsPx9mWiy+HGX9JQ8qZFnyUT2R5blzqY0d2rEzLdRyYBpWXuI WkB01RBdJJmYW9ZHVaXSevwwAtpVlx4aiK4eORfPiAZW7smBqIiMrZB3dIL8pQWK LKbmop41Vep3goTh+EJ3dlDWlB5R6/cTf8M3jQ/Lxq5sC2vreCTgryBaoxCXYAAf nj3EFxMgyaSvUwzy/3WUIulQUPtmSaQro/EsCVTb6S24dX3vcAVjiSZ8PRa8hY28 3eI6NuUIhRDxB1PIeeaDUgUjQZw8NEWW1TBunj8+lX6UP9OB+NZ2hJt7Q6t06dFw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrvdeggddviecutefuodetggdotefrodftvf 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 3EF2C240065; Mon, 25 Jan 2021 19:54:51 -0500 (EST) Date: Tue, 26 Jan 2021 09:54:48 +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="mU07yZAdo/urzYm9" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --mU07yZAdo/urzYm9 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Jan 25, 2021 at 08:53:39PM +0530, harisai hari wrote: > Thank you! Yes, this page is wrong to tell that. 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. Thoughts? -- Michael --mU07yZAdo/urzYm9 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmAPaFgACgkQnvQgOdby QH3jBQ/+JipW3g41W9Fvfvbb2juzhny7IZHW1xhOfly3KGkx4lqblCKPrd/CW7+o /IAPyR6NqCi5sho+mJ4bATI+ilLbDP/43RjEkr9jpwfsVwRPfZLCsecm7wrzqVwL U6Ste91c4wZsEIMAJCXMCJSj1OalwEYBP4izGFdToh6DB05Kf0cFTeGHCPB3TXaq 4iWuhrcFVXyPAMhY3Z7lyaP6zeUNkADN3JaEskeWhVE2c2lOiAiDgcXcBROC/uUc hw1/FMfpm5nAfyI9C2soRPePUIXSjRrNw0MWh1sZijU+CvGKvpcSmHoiio51xke/ BqsPAC2MzHEEEWntCQp4l4UJ+mHhv2Dcljs7uKgHuyWkSQoBk8kbBGMERhuA7b5g 7YEvQRn0bdHgipEx7wqp5d5s/5FhfURHjSMIHmJP5yNKxE6dfiei/K9+plGOVs5D YUI2Tte1Ge9ySGY4t057Rn4kNZ9EHy1zhINEC4oKFF2aLpXMO+uTU6h1GI/nDlNZ 27jCzWyuslZGMyuY+vjZhuyQE6lg8SyACciY52v3mXZob6t7Gh9gxoqNxSsGTl5h XUpJnIlgj2CQ23aF3zFhz9g75cEP/l2yk0EGWjfALzTseOkkj1xBzdz+2w+YKXLe hKLEFfLhqGl+A0YTGYwEsiUdC4v8DGkNy6K+Dsf4FlPRDT8WSBM= =FhXd -----END PGP SIGNATURE----- --mU07yZAdo/urzYm9--