@@ -7,7 +7,7 @@ CREATE OR REPLACE FUNCTION @extschema@.create_range_partitions(
7
7
, p_start_value ANYELEMENT
8
8
, p_interval INTERVAL
9
9
, p_premakeINTEGER )
10
- RETURNSVOID AS
10
+ RETURNSINTEGER AS
11
11
$$
12
12
DECLARE
13
13
v_valueTEXT ;
16
16
p_relation := @extschema@.validate_relname(p_relation);
17
17
18
18
IF EXISTS (SELECT * FROM @extschema@.pathman_configWHERE relname= p_relation) THEN
19
- RAISE EXCEPTION' Reltion "%" has already been partitioned' , p_relation;
19
+ RAISE EXCEPTION' Relation "%" has already been partitioned' , p_relation;
20
20
END IF;
21
21
22
22
EXECUTE format(' DROP SEQUENCE IF EXISTS %s_seq' , p_relation);
39
39
-- PERFORM create_hash_update_trigger(relation, attribute, partitions_count);
40
40
/* Notify backend about changes*/
41
41
PERFORM @extschema@.on_create_partitions(p_relation::regclass::oid );
42
+
43
+ RETURN p_premake+ 1 ;
42
44
END
43
45
$$ LANGUAGE plpgsql;
44
46
@@ -51,7 +53,7 @@ CREATE OR REPLACE FUNCTION @extschema@.create_range_partitions(
51
53
, p_start_value ANYELEMENT
52
54
, p_interval ANYELEMENT
53
55
, p_premakeINTEGER )
54
- RETURNSVOID AS
56
+ RETURNSINTEGER AS
55
57
$$
56
58
DECLARE
57
59
v_valueTEXT ;
60
62
p_relation := @extschema@.validate_relname(p_relation);
61
63
62
64
IF EXISTS (SELECT * FROM @extschema@.pathman_configWHERE relname= p_relation) THEN
63
- RAISE EXCEPTION' Reltion "%" has already been partitioned' , p_relation;
65
+ RAISE EXCEPTION' Relation "%" has already been partitioned' , p_relation;
64
66
END IF;
65
67
66
68
EXECUTE format(' DROP SEQUENCE IF EXISTS %s_seq' , p_relation);
83
85
-- PERFORM create_hash_update_trigger(relation, attribute, partitions_count);
84
86
/* Notify backend about changes*/
85
87
PERFORM @extschema@.on_create_partitions(p_relation::regclass::oid );
88
+
89
+ RETURN p_premake+ 1 ;
86
90
END
87
91
$$ LANGUAGE plpgsql;
88
92