Eli Mesika has uploaded a new change for review.
Change subject: core: fixing PG 8.4 compatability
......................................................................
core: fixing PG 8.4 compatability
Since FOREACH is supported only for PG 9.x the following script uses the
unnest functions instead.
Change-Id: I19cabe0b559abc8e505ce8712065a147631fd75e
Signed-off-by: Eli Mesika <emes...@redhat.com>
---
M packaging/dbscripts/common_sp.sql
1 file changed, 3 insertions(+), 2 deletions(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/07/25807/1
diff --git a/packaging/dbscripts/common_sp.sql
b/packaging/dbscripts/common_sp.sql
index da0fa6d..0e5a04c 100644
--- a/packaging/dbscripts/common_sp.sql
+++ b/packaging/dbscripts/common_sp.sql
@@ -568,7 +568,7 @@
v_result := '';
v_sep := '';
v := string_to_array(option_value, ',') from vdc_options where option_name
= v_option_name and version = v_version;
- FOREACH e in ARRAY v
+ FOR e in select unnest(v)
LOOP
IF (e != v_value) THEN
v_result := v_result || v_sep || e;
@@ -577,4 +577,5 @@
END LOOP;
UPDATE vdc_options set option_value = v_result where option_name =
v_option_name and version = v_version;
END; $procedure$
-LANGUAGE plpgsql;
\ No newline at end of file
+LANGUAGE plpgsql;
+
--
To view, visit http://gerrit.ovirt.org/25807
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I19cabe0b559abc8e505ce8712065a147631fd75e
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Eli Mesika <emes...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
