Partitioning by month causing an error?

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Partitioning by month causing an error?
Дата
Msg-id CAOC+FBW=zSLyHWg2XDTp2eeEAmwzkzZLQPBqFx7_Cso=WMK3ew@mail.gmail.com
обсуждение исходный текст
Ответы Re: Partitioning by month causing an error?  (Ron <ronljohnsonjr@gmail.com>)
Re: Partitioning by month causing an error?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Partitioning by month causing an error?  (Gaetano Mendola <mendola@gmail.com>)
Список pgsql-admin
I have a partition per each month, like this:

CREATE TABLE mmd_yr2019_3 PARTITION OF mmd FOR VALUES FROM ('2019-03-01') TO ('2019-03-31');
CREATE TABLE mmd_yr2019_4 PARTITION OF mmd FOR VALUES FROM ('2019-04-01') TO ('2019-04-30');

This breaks for dates at the end of the month. What's the better way to write the bounds? 3/1 to 4/1 and then 4/1 to 5/1? Does that cause some overlap issue?

Thanks.

--

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

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Partitioning stats view?
Следующее
От: Ron
Дата:
Сообщение: Re: Partitioning by month causing an error?