Partitioning by month causing an error? - Mailing list pgsql-admin

From Wells Oliver
Subject Partitioning by month causing an error?
Date
Msg-id CAOC+FBW=zSLyHWg2XDTp2eeEAmwzkzZLQPBqFx7_Cso=WMK3ew@mail.gmail.com
Whole thread Raw
Responses Re: Partitioning by month causing an error?
Re: Partitioning by month causing an error?
Re: Partitioning by month causing an error?
List 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 by date:

Previous
From: Wells Oliver
Date:
Subject: Partitioning stats view?
Next
From: Ron
Date:
Subject: Re: Partitioning by month causing an error?