Re: Partitioning by month causing an error?

Gaetano Mendola <[email protected]> Sat, 21 Dec 2019 11:09:40 +0100

Newsgroups	gmane.comp.db.postgresql.admin
Message-ID	<CAJycT5rRbAsO-5wzz3fb7umBD=gjKvW6Oe=OkjpARAdWTqSvrw@mail.gmail.com>

On Sat, Dec 21, 2019 at 1:49 AM Wells Oliver <[email protected]> wrote:
>
> 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?

This should have been:

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


-- 
cpp-today.blogspot.com