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 1o3nNZ-0003o1-Pm for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Jun 2022 23:33:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o3nNY-0003oR-Js for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Jun 2022 23:33:52 +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 1o3nNY-0003oI-Bh for pgsql-bugs@lists.postgresql.org; Tue, 21 Jun 2022 23:33:52 +0000 Received: from smtp112.iad3a.emailsrvr.com ([173.203.187.112]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o3nNT-0001FL-9O for pgsql-bugs@lists.postgresql.org; Tue, 21 Jun 2022 23:33:51 +0000 X-Auth-ID: xof@thebuild.com Received: by smtp7.relay.iad3a.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 7D61C4C42; Tue, 21 Jun 2022 19:33:45 -0400 (EDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: Re: BUG #17525: Range partition by date won't allow the use of a date that is the upper bound From: Christophe Pettus In-Reply-To: <17525-ffa3a5fe34f8c6f4@postgresql.org> Date: Tue, 21 Jun 2022 16:33:38 -0700 X-Mailbutler-Message-Id: 19D59672-BCB9-4384-86AD-8EC8B0C87E55 Content-Transfer-Encoding: quoted-printable Message-Id: <7D0BE81B-40BA-4901-973E-70FFC4C01034@thebuild.com> References: <17525-ffa3a5fe34f8c6f4@postgresql.org> To: allen.sutton@valocityglobal.com, pgsql-bugs@lists.postgresql.org X-Mailer: Apple Mail (2.3608.120.23.2.7) X-Classification-ID: 130d0b89-3913-4b3c-bf9c-840f40fbe255-1-1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jun 21, 2022, at 16:11, PG Bug reporting form = wrote: > e.g. CREATE TABLE avm.avm_history_201704 PARTITION OF = avm.avm_history_part > FOR VALUES FROM ('2017-04-01') TO ('2017-04-30'); The upper bound on a range partition is exclusive: The partition is = defined as from 2017-04-01 up to, but not including 2017-04-30. If you = want full-month partitions, you probably want the upper bound to be = 2017-05-01 (in this example).=