ERROR: Partitioning key 'value' must be NOT NULL

ALTER TABLE test.hash_rel ALTER COLUMN value SET NOT NULL;

SELECT pathman.create_hash_partitions('test.hash_rel', 'Value', 3);

NOTICE: Copying data to partitions...

create_hash_partitions

------------------------

3

* Test CTE query

*/

EXPLAIN (COSTS OFF)

WITH ttt AS (SELECT * FROM test.range_rel WHERE dt >= '2015-02-01' AND dt < '2015-03-15')

WITH ttt AS (SELECT * FROM test.range_rel WHERE dt >= '2015-02-01' AND dt < '2015-03-15')

SELECT * FROM ttt;

QUERY PLAN

--------------------------------------------------------------------------------------------

(6 rows)

EXPLAIN (COSTS OFF)

WITH ttt AS (SELECT * FROM test.hash_rel WHERE value = 2)

WITH ttt AS (SELECT * FROM test.hash_rel WHERE value = 2)

SELECT * FROM ttt;

QUERY PLAN

--------------------------------------

create table test.runtime_test_1(id serial primary key, val real);

insert into test.runtime_test_1 select generate_series(1, 10000), random();

select pathman.create_hash_partitions('test.runtime_test_1', 'id', 6);

NOTICE: Copying data to partitions...

create_hash_partitions

------------------------

6

insert into test.runtime_test_2 (select id, (id % 6) + 1 as category_id, 'good' || id::text as name, random() as rating from generate_series(1, 100000) id);

create index on test.runtime_test_2 (category_id, rating);

select pathman.create_hash_partitions('test.runtime_test_2', 'category_id', 6);

NOTICE: Copying data to partitions...

create_hash_partitions

------------------------

6

create table test.runtime_test_3(val text, id serial not null);

insert into test.runtime_test_3(id, val) select * from generate_series(1, 10000) k, format('k = %s', k);

select pathman.create_hash_partitions('test.runtime_test_3', 'id', 4);

NOTICE: Copying data to partitions...

create_hash_partitions

------------------------

4

*/

/* Split first partition in half */

SELECT pathman.split_range_partition('test.num_range_rel_1', 500);

NOTICE: Creating new partition...

NOTICE: Copying data to new partition...

NOTICE: Altering original partition...

NOTICE: Done!

split_range_partition

-----------------------

{0,1000}

(5 rows)

SELECT pathman.split_range_partition('test.range_rel_1', '2015-01-15'::DATE);

NOTICE: Creating new partition...

NOTICE: Copying data to new partition...

NOTICE: Altering original partition...

NOTICE: Done!

split_range_partition

-------------------------

{01-01-2015,02-01-2015}

(1 row)

/* Merge two partitions into one */

SELECT pathman.merge_range_partitions('test.num_range_rel_1', 'test.num_range_rel_' || currval('test.num_range_rel_seq'));

NOTICE: Altering first partition...

NOTICE: Copying data...

NOTICE: Dropping second partition...

NOTICE: Done!

merge_range_partitions

------------------------

(3 rows)

SELECT pathman.merge_range_partitions('test.range_rel_1', 'test.range_rel_' || currval('test.range_rel_seq'));

NOTICE: Altering first partition...

NOTICE: Copying data...

NOTICE: Dropping second partition...

NOTICE: Done!

merge_range_partitions

------------------------

(1 row)

/* Append and prepend partitions */

SELECT pathman.append_range_partition('test.num_range_rel');

NOTICE: Appending new partition...

NOTICE: Done!

append_range_partition

------------------------

test.num_range_rel_6

(2 rows)

SELECT pathman.prepend_range_partition('test.num_range_rel');

NOTICE: Prepending new partition...

NOTICE: Done!

prepend_range_partition

-------------------------

test.num_range_rel_7

(1 row)

SELECT pathman.append_range_partition('test.range_rel');

NOTICE: Appending new partition...

NOTICE: Done!

append_range_partition

------------------------

test.range_rel_6

(1 row)

SELECT pathman.prepend_range_partition('test.range_rel');

NOTICE: Prepending new partition...

NOTICE: Done!

prepend_range_partition

-------------------------

test.range_rel_7

SELECT pathman.add_range_partition('test.range_rel', '2014-12-01'::DATE, '2015-01-02'::DATE);

ERROR: Specified range overlaps with existing partitions

SELECT pathman.add_range_partition('test.range_rel', '2014-12-01'::DATE, '2015-01-01'::DATE);

NOTICE: Done!

add_range_partition

---------------------

test.range_rel_8

(4 rows)

CREATE TABLE test.range_rel_test1 (

id SERIAL PRIMARY KEY,

dt TIMESTAMP,

txt TEXT,

abc INTEGER);

id SERIAL PRIMARY KEY,

dt TIMESTAMP,

txt TEXT,

abc INTEGER);

SELECT pathman.attach_range_partition('test.range_rel', 'test.range_rel_test1', '2013-01-01'::DATE, '2014-01-01'::DATE);

ERROR: Partition must have the exact same structure as parent

CREATE TABLE test.range_rel_test2 (

id SERIAL PRIMARY KEY,

dt TIMESTAMP);

id SERIAL PRIMARY KEY,

dt TIMESTAMP);

SELECT pathman.attach_range_partition('test.range_rel', 'test.range_rel_test2', '2013-01-01'::DATE, '2014-01-01'::DATE);

ERROR: Partition must have the exact same structure as parent

/*

(1 row)

SELECT pathman.create_hash_partitions('test.hash_rel', 'value', 3);

NOTICE: Copying data to partitions...

create_hash_partitions

------------------------

3

DROP TABLE test.range_rel CASCADE;

NOTICE: drop cascades to 16 other objects

SELECT * FROM pathman.pathman_config;

id |relname | attname | parttype | range_interval

id |partrel | attname | parttype | range_interval

----+---------+---------+----------+----------------

(0 rows)

SELECT pathman.create_hash_partitions('test.TeSt', 'a', 3);

ERROR: relation "test.test" does not exist at character 39

SELECT pathman.create_hash_partitions('test."TeSt"', 'a', 3);

NOTICE: Copying data to partitions...

create_hash_partitions

------------------------

3

(1 row)

SELECT pathman.append_range_partition('test."RangeRel"');

NOTICE: Appending new partition...

NOTICE: Done!

append_range_partition

------------------------

test."RangeRel_4"

(1 row)

SELECT pathman.prepend_range_partition('test."RangeRel"');

NOTICE: Prepending new partition...

NOTICE: Done!

prepend_range_partition

-------------------------

test."RangeRel_5"

(1 row)

SELECT pathman.merge_range_partitions('test."RangeRel_1"', 'test."RangeRel_' || currval('test."RangeRel_seq"') || '"');

NOTICE: Altering first partition...

NOTICE: Copying data...

NOTICE: Dropping second partition...

NOTICE: Done!

merge_range_partitions

------------------------

(1 row)

SELECT pathman.split_range_partition('test."RangeRel_1"', '2015-01-01'::DATE);

NOTICE: Creating new partition...

NOTICE: Copying data to new partition...

NOTICE: Altering original partition...

NOTICE: Done!

split_range_partition

-------------------------

{12-31-2014,01-02-2015}

DROP TABLE test."RangeRel" CASCADE;

NOTICE: drop cascades to 5 other objects

SELECT * FROM pathman.pathman_config;

id |relname | attname | parttype | range_interval

id |partrel | attname | parttype | range_interval

----+--------------------+---------+----------+----------------

9 | test.num_range_rel | id | 2 | 1000

(1 row)

valueINTEGER NOT NULL);

INSERT INTO hash_rel (value) SELECT g FROM generate_series(1, 10000) as g;

SELECT create_hash_partitions('hash_rel', 'value', 3);

NOTICE: Copying data to partitions...

create_hash_partitions

------------------------

3

(1 row)

SELECT merge_range_partitions('range_rel_1', 'range_rel_2');

NOTICE: Altering first partition...

NOTICE: Copying data...

NOTICE: Dropping second partition...

NOTICE: Done!

merge_range_partitions

------------------------

(1 row)

SELECT split_range_partition('range_rel_1', '2010-02-15'::date);

NOTICE: Creating new partition...

NOTICE: Copying data to new partition...

NOTICE: Altering original partition...

NOTICE: Done!

split_range_partition

-------------------------

{01-01-2010,03-01-2010}

(1 row)

SELECT append_range_partition('range_rel');

NOTICE: Appending new partition...

NOTICE: Done!

append_range_partition

------------------------

public.range_rel_14

(1 row)

SELECT prepend_range_partition('range_rel');

NOTICE: Prepending new partition...

NOTICE: Done!

prepend_range_partition

-------------------------

public.range_rel_15

#defineDebugPrintDatum(datum,typid) ( datum_to_cstring((datum), (typid)) )

#defineDebugPrintDatum(datum,typid) ( "[use --enable-cassert]" )