test arg relnames := ARRAY[...]::TEXT[] of create_hash_partitions()

funbringer · funbringer · commit d2ff1380609b · 2017-02-10T19:25:05.000+03:00
diff --git a/expected/pathman_basic.out b/expected/pathman_basic.out
@@ -2430,6 +2430,31 @@ SELECT * FROM test;
  
 (4 rows)
 
+/* Test create_range_partitions() + relnames */
+CREATE TABLE test.provided_part_names(id INT NOT NULL);
+INSERT INTO test.provided_part_names SELECT generate_series(1, 10);
+SELECT create_hash_partitions('test.provided_part_names', 'id', 2,
+							  relnames := ARRAY[]::TEXT[]);				/* not ok */
+ERROR:  size of array 'relnames' must be equal to 'partitions_count'
+SELECT create_hash_partitions('test.provided_part_names', 'id', 2,
+							  relnames := ARRAY['p1', 'p2']::TEXT[]);	/* ok */
+ create_hash_partitions 
+------------------------
+                      2
+(1 row)
+
+/* list partitions */
+SELECT partition FROM pathman_partition_list
+WHERE parent = 'test.provided_part_names'::REGCLASS
+ORDER BY partition;
+ partition 
+-----------
+ p1
+ p2
+(2 rows)
+
+DROP TABLE test.provided_part_names CASCADE;
+NOTICE:  drop cascades to 2 other objects
 DROP SCHEMA test CASCADE;
 NOTICE:  drop cascades to 54 other objects
 DROP EXTENSION pg_pathman CASCADE;
diff --git a/sql/pathman_basic.sql b/sql/pathman_basic.sql
@@ -700,6 +700,21 @@ WITH RECURSIVE test AS (
 SELECT * FROM test;
 
 
+/* Test create_range_partitions() + relnames */
+CREATE TABLE test.provided_part_names(id INT NOT NULL);
+INSERT INTO test.provided_part_names SELECT generate_series(1, 10);
+SELECT create_hash_partitions('test.provided_part_names', 'id', 2,
+							  relnames := ARRAY[]::TEXT[]);				/* not ok */
+SELECT create_hash_partitions('test.provided_part_names', 'id', 2,
+							  relnames := ARRAY['p1', 'p2']::TEXT[]);	/* ok */
+/* list partitions */
+SELECT partition FROM pathman_partition_list
+WHERE parent = 'test.provided_part_names'::REGCLASS
+ORDER BY partition;
+
+DROP TABLE test.provided_part_names CASCADE;
+
+
 DROP SCHEMA test CASCADE;
 DROP EXTENSION pg_pathman CASCADE;
 DROP SCHEMA pathman CASCADE;
