ERROR: Partitioning key 'dt' must be NOT NULL

ALTER TABLE test.range_rel ALTER COLUMN dt SET NOT NULL;

SELECT pathman.create_range_partitions('test.range_rel', 'dt', '2015-01-01'::DATE, '1 month'::INTERVAL, 2);

ERROR: Not enough partitions to fit allthevalues of 'dt'

ERROR: Not enough partitions to fit all values of 'dt'

SELECT pathman.create_range_partitions('test.range_rel', 'DT', '2015-01-01'::DATE, '1 month'::INTERVAL);

NOTICE: sequence "range_rel_seq" does not exist, skipping

create_range_partitions

EXECUTE format('CREATE TABLE %1$s (LIKE %2$s INCLUDING ALL) INHERITS (%2$s)',

v_child_relname,

@extschema@.get_schema_qualified_name(parent_relid));

parent_relid::TEXT);

EXECUTE format('ALTER TABLE %s ADD CONSTRAINT %s

CHECK (@extschema@.get_hash_part_idx(%s(%s), %s) = %s)',

attr := attnameFROM @extschema@.pathman_configWHERE partrel= parent_relid;

IF attr ISNULL THEN

RAISE EXCEPTION'Table% is not partitioned',quote_ident(parent_relid::TEXT);

RAISE EXCEPTION'Table"%" is not partitioned', parent_relid::TEXT;

END IF;

SELECT string_agg(attname,','),

EXECUTE format('WITH part_data AS (DELETE FROM ONLY %1$s RETURNING *)

INSERT INTO %1$s SELECT * FROM part_data',

@extschema@.get_schema_qualified_name(parent_relid));

parent_relid::TEXT);

GET DIAGNOSTICS p_total= ROW_COUNT;

IF rel_persistence='t'::CHAR THEN

RAISE EXCEPTION'Temporary table "%" cannot be partitioned',

quote_ident(p_relation::TEXT);

p_relation::TEXT;

END IF;

IF EXISTS (SELECT*FROM @extschema@.pathman_config