Re: Issue with partitioning - legitimate insert fails with no partition message

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Issue with partitioning - legitimate insert fails with no partition message
Дата
Msg-id 9F1653B6-2CC5-41BD-B63B-14927FF90081@elevated-dev.com
обсуждение исходный текст
Ответ на Re: Issue with partitioning - legitimate insert fails with no partition message  (Sbob <sbob@quadratum-braccas.com>)
Список pgsql-admin
> 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
thisis 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,
orXXX.99999... Same argument applies to timestamps--even though they are stored as 64-bit integers, how would you
figureout the value that is 1 bit less than your end date? 





В списке pgsql-admin по дате отправления:

Предыдущее
От: Sbob
Дата:
Сообщение: Re: Issue with partitioning - legitimate insert fails with no partition message
Следующее
От: "yanliang lei"
Дата:
Сообщение: Does Postgresql support 4KN/512e HDD/SSD?