jobinau / pg_partmaint Goto Github PK

CREATE TABLE public.tab1_p0 PARTITION OF public.tab1 FOR VALUES FROM ('0') TO ('500000');

./pg_partmaint.py -c "" -t public.tab1 -i 5000000 -p 40 --display

 CREATE TABLE public.tab1_p0 PARTITION OF public.tab1 FOR VALUES FROM ('0') TO ('5000000')
 CREATE TABLE public.tab1_p5000000 PARTITION OF public.tab1 FOR VALUES FROM ('5000000') TO ('10000000')
 CREATE TABLE public.tab1_p10000000 PARTITION OF public.tab1 FOR VALUES FROM ('10000000') TO ('15000000')
 CREATE TABLE public.tab1_p15000000 PARTITION OF public.tab1 FOR VALUES FROM ('15000000') TO ('20000000')

CREATE TABLE emp (id int,
dob timestamp(6) without time zone
) 
PARTITION BY RANGE (dob);
CREATE TABLE public."emp_2019-01-01_2020-11-30" PARTITION OF emp FOR VALUES FROM ('2019-01-01 00:00:00') TO ('2020-11-30 00:00:00');
CREATE TABLE public."emp_2020-11-30_2020-12-01" PARTITION OF emp FOR VALUES FROM ('2020-11-30 00:00:00') TO ('2020-12-01 00:00:00');
CREATE TABLE public."emp_2020-12-01_2020-12-02" PARTITION OF emp FOR VALUES FROM ('2020-12-01 00:00:00') TO ('2020-12-02 00:00:00');
CREATE TABLE public.emp_default PARTITION OF emp DEFAULT;

./pg_partmaint.py -c "" -t public.emp -i weekly -p 5 --displayddl
Version: 3.1
Connecting to Databse...
Verified that table : public.emp is a partitioned table
Current Number of Free Partitions in the table :4
Preparing 1 more new partition(s)
Traceback (most recent call last):
  File "./pg_partmaint.py", line 188, in <module>
    tab1.prepareNewPartitions(int(args.premake)-freeParts)
  File "./pg_partmaint.py", line 121, in prepareNewPartitions
    cur.execute(sql)
  File "/usr/local/lib/python2.7/dist-packages/psycopg2/extras.py", line 243, in execute
    return super(RealDictCursor, self).execute(query, vars)
psycopg2.errors.InvalidDatetimeFormat: invalid input syntax for type date: "ULT"