Thanks !! Ranjeet for the reply . Getting below err while inserting for nov. insert into measurement values(1,'2017-11-15',10,10); ERROR: date/time field value out of range: "2017-11-31" CONTEXT: SQL statement "CREATE TABLE measurement_2017_11_p2 ( CHECK ( logdate >= DATE '2017-11-15' AND logdate < DATE '2017-11-31' )) INHERITS (measurement);" PL/pgSQL function new_partition_creator() line 24 at EXECUTE statement SQL state: 22008
... View more