Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ce0Sg-0008D8-ML for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Feb 2017 14:21:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ce0Sf-0001Uv-Lh for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Feb 2017 14:21:37 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ce0RF-0008H2-De for pgsql-hackers@postgresql.org; Wed, 15 Feb 2017 14:20:09 +0000 Received: from lists.commandprompt.com ([69.168.55.30]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ce0RC-0006UN-0c for pgsql-hackers@postgresql.org; Wed, 15 Feb 2017 14:20:07 +0000 Received: from [192.168.1.61] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 7E7316A1; Wed, 15 Feb 2017 06:20:03 -0800 (PST) Received: from c-73-225-27-179.hsd1.wa.comcast.net ([73.225.27.179] helo=[192.168.1.61]) by assp.commandprompt.com with SMTPSA(TLSv1_2 ECDHE-RSA-AES128-GCM-SHA256) (2.5.1); 15 Feb 2017 06:20:03 -0800 Subject: Re: Documentation improvements for partitioning To: Simon Riggs , Amit Langote References: <89ebfd64-e32e-5a23-139e-0db816390091@lab.ntt.co.jp> <4ee94808-968a-57d7-c12a-a18f08138a2f@lab.ntt.co.jp> Cc: Corey Huinker , Pg Hackers From: "Joshua D. Drake" Organization: Command Prompt, Inc. Message-ID: <8c673d74-8385-438e-c89d-be63f731da67@commandprompt.com> Date: Wed, 15 Feb 2017 06:20:02 -0800 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.5.1(16177) on assp.commandprompt.com X-Assp-ID: assp.commandprompt.com m1-68403-01101 X-Assp-Session: 7F78E858DFF8 (mail 1) X-Assp-Original-Subject: Re: [HACKERS] Documentation improvements for partitioning X-Assp-Client-SSL: yes X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 02/15/2017 06:10 AM, Simon Riggs wrote: > On 13 February 2017 at 05:21, Amit Langote > wrote: > If I issue DROP TABLE elsewhere, it doesn't refuse to drop because it > has indexes, sequences etc on it. So why should it just because it has > partitions? Because partitions may have data. JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers