disable_partitioning() bugfix

zilder · zilder · commit 115dc684778e · 2016-05-23T17:35:26.000+03:00
diff --git a/init.sql b/init.sql
@@ -120,15 +120,15 @@ CREATE OR REPLACE FUNCTION @extschema@.disable_partitioning(IN relation TEXT)
 RETURNS VOID AS
 $$
 DECLARE
-	parttype INTEGER;
+	v_parttype INTEGER;
 BEGIN
 	relation := @extschema@.validate_relname(relation);
-	parttype := parttype FROM pathman_config WHERE relname = relation;
+	v_parttype := parttype FROM pathman_config WHERE relname = relation;
 
 	DELETE FROM @extschema@.pathman_config WHERE relname = relation;
-	IF parttype = 1 THEN
+	IF v_parttype = 1 THEN
 		PERFORM @extschema@.drop_hash_triggers(relation);
-	ELSIF parttype = 2 THEN
+	ELSIF v_parttype = 2 THEN
 		PERFORM @extschema@.drop_range_triggers(relation);
 	END IF;
 
