Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b0mPm-0004AG-Sr for pgsql-hackers@arkaria.postgresql.org; Thu, 12 May 2016 08:56:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b0mPm-00037w-Cg for pgsql-hackers@arkaria.postgresql.org; Thu, 12 May 2016 08:56:14 +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 1b0mPl-00036A-Qo for pgsql-hackers@postgresql.org; Thu, 12 May 2016 08:56:13 +0000 Received: from tama50.ecl.ntt.co.jp ([129.60.39.147]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b0mPh-0008CK-8e for pgsql-hackers@postgresql.org; Thu, 12 May 2016 08:56:12 +0000 Received: from vc2.ecl.ntt.co.jp (vc2.ecl.ntt.co.jp [129.60.86.154]) by tama50.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id u4C8u6tg007405; Thu, 12 May 2016 17:56:06 +0900 Received: from vc2.ecl.ntt.co.jp (localhost [127.0.0.1]) by vc2.ecl.ntt.co.jp (Postfix) with ESMTP id 075A35F594; Thu, 12 May 2016 17:56:06 +0900 (JST) Received: from jcms-pop22.ecl.ntt.co.jp (jcms-pop22.ecl.ntt.co.jp [129.60.87.135]) by vc2.ecl.ntt.co.jp (Postfix) with ESMTP id EEC315F592; Thu, 12 May 2016 17:56:05 +0900 (JST) Received: from [127.0.0.1] (unknown [129.60.241.61]) by jcms-pop22.ecl.ntt.co.jp (Postfix) with ESMTP id E260FD4036D; Thu, 12 May 2016 17:56:05 +0900 (JST) Subject: Re: Declarative partitioning References: <57106F9E.3000309@lab.ntt.co.jp> <57163954.2020701@postgrespro.ru> <571759D8.7030205@lab.ntt.co.jp> <57179653.30905@postgrespro.ru> <57183572.8020900@lab.ntt.co.jp> <5731BA97.9090108@lab.ntt.co.jp> <1463042549530-5903204.post@n5.nabble.com> From: Amit Langote Message-ID: <57344510.4000705@lab.ntt.co.jp> Date: Thu, 12 May 2016 17:55:44 +0900 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.7.2 MIME-Version: 1.0 In-Reply-To: <1463042549530-5903204.post@n5.nabble.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit To: Sameer Thakur-2 , pgsql-hackers@postgresql.org X-TM-AS-MML: disable X-Pg-Spam-Score: -4.0 (----) 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 Hi, On 2016/05/12 17:42, Sameer Thakur-2 wrote: > Hello Amit, > In the example >> create table part201606week4 partition of parted >> for values start (2016, 6, 2) end (2016, 6, 29); > > seems to be a typo Oops, there indeed is. create table part201606week4 partition of parted for values start (2016, 6, 2) end (2016, 6, 29); create table part201606week4 partition of parted for values start (2016, 6, 22) end (2016, 6, 29); While copy-pasting part201606week4's definition from a previous line, ended up pasting twice and then edited the second one to the correct definition. Thanks, Amit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers