From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Sbob <sbob@quadratum-braccas.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Issue with partitioning - legitimate insert fails with no partition message
Date: Fri, 30 Sep 2022 09:29:52 -0600
Message-ID: <9F1653B6-2CC5-41BD-B63B-14927FF90081@elevated-dev.com> (raw)
In-Reply-To: <42b71a74-1439-4bfa-5a3f-727e712c2ca0@quadratum-braccas.com>
References: <2121b49f-52fb-ab79-3ea1-c398d7a8656f@quadratum-braccas.com>
<42b71a74-1439-4bfa-5a3f-727e712c2ca0@quadratum-braccas.com>
> On Sep 30, 2022, at 9:21 AM, Sbob <sbob@quadratum-braccas.com> wrote:
>
> It seems that the range for partitions is inclusive of the starting value and exclusive of the ending value, maybe this is documented and I missed it?
Yes, it is. (and "to" is not "through")
The explanation is: think of a floating-point value, if it included the end value would you use XXX.999, or XXX.9999, or XXX.99999... Same argument applies to timestamps--even though they are stored as 64-bit integers, how would you figure out the value that is 1 bit less than your end date?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, sbob@quadratum-braccas.com, pgsql-admin@lists.postgresql.org
Subject: Re: Issue with partitioning - legitimate insert fails with no partition message
In-Reply-To: <9F1653B6-2CC5-41BD-B63B-14927FF90081@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox