Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1rp6gV-0055Uq-Sk
	for pgsql-docs@arkaria.postgresql.org; Tue, 26 Mar 2024 13:17:48 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1rp6gU-00Edoo-Up
	for pgsql-docs@arkaria.postgresql.org; Tue, 26 Mar 2024 13:17:46 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <gparc@free.fr>)
	id 1rp6gU-00EdoY-Mg
	for pgsql-docs@lists.postgresql.org; Tue, 26 Mar 2024 13:17:46 +0000
Received: from smtp3-g21.free.fr ([2a01:e0c:1:1599::12])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <gparc@free.fr>)
	id 1rp6gQ-006XBu-Pr
	for pgsql-docs@lists.postgresql.org; Tue, 26 Mar 2024 13:17:45 +0000
Received: from zimbra-e1-02.priv.proxad.net (unknown [172.20.243.240])
	by smtp3-g21.free.fr (Postfix) with ESMTP id 243E613F89A
	for <pgsql-docs@lists.postgresql.org>; Tue, 26 Mar 2024 14:17:41 +0100 (CET)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=free.fr;
	s=smtp-20201208; t=1711459061;
	bh=L1550yIodpzFuMNHIKkUtK8hMscWAlfuz7fmZ1TJCv4=;
	h=Date:From:To:Subject:From;
	b=BgbZtiL+0Z/G+Pmftwb+Uz+1PaQfUs+h3ySRkO0lRk0FjJIXLVr1Bpq2BgcmoYE9H
	 q5uoaCfx6TpFri8Ks9UJqimVUHSKz5ZJ2W8FPmABQn7JVtgTnS9UYKJduhQsNC+UOg
	 TgeRgR1+Muss2sUphYR0fSL7VzsHSy976TBd6C6ZMo0NGeNpx0IngRtK5vUlmNoHad
	 6R9fW7urYwZsrZa9bgrwbjGFOlSw86tGHrPyobFpz6m59syCAeFHC+HZj0aPpTDJcw
	 EnRHwSU2s8zwICepTo0alWO+xzB2Puya1UFsdCbd1ESpedFoRWO2l9USuqNMN0NF8b
	 Ax9jLDItQY+qA==
Date: Tue, 26 Mar 2024 14:17:41 +0100 (CET)
From: gparc@free.fr
To: pgsql-docs <pgsql-docs@lists.postgresql.org>
Message-ID: <129938207.827117930.1711459061107.JavaMail.zimbra@free.fr>
Subject: Drop a partitioned table "side effect"
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=_920597f4-0a14-410e-be53-715933957f07"
X-Originating-IP: [145.242.20.121]
X-Mailer: Zimbra 9.0.0_GA_1337 (ZimbraWebClient - FF115 (Linux)/9.0.0_GA_1337)
Thread-Index: SEPALG0iaJ55XVsn7mOFnhlEbFyZ6g==
Thread-Topic: Drop a partitioned table "side effect"
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/129938207.827117930.1711459061107.JavaMail.zimbra%40free.fr>
Precedence: bulk

--=_920597f4-0a14-410e-be53-715933957f07
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


Hello, 

for a partitioned table, it should be mentioned in the documentation that currently the drop will also silently 
drop all the partitions underneath. 
By the way, it's a pity that "cascade" is not considered to be used in such a case. 

Regards 
Gilles 

--=_920597f4-0a14-410e-be53-715933957f07
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div><br data-mce-bogus="1"></div><div>Hello,<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>for a partitioned table, it should be mentioned in the documentation that currently the drop will also silently <br>drop all the partitions underneath.<br>By the way, it's a pity that "cascade" is not considered to be used in such a case.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Regards<br data-mce-bogus="1"></div><div>Gilles<br data-mce-bogus="1"></div></div></body></html>
--=_920597f4-0a14-410e-be53-715933957f07--