Alex Lourie has uploaded a new change for review.
Change subject: packaging: Updated fkvalidator SP to drop function before
recreating
......................................................................
packaging: Updated fkvalidator SP to drop function before recreating
This package updates the fkvalidator_sp with drop
function call, so that this stored procedure can be loaded
into older databases (the signature of the function changed,
so it cannot be overwritten, only recreated).
Change-Id: Ic20625ed61caf8f1aaff4860c18f048402b32353
Signed-off-by: Alex Lourie <alou...@redhat.com>
---
M backend/manager/tools/dbutils/fkvalidator_sp.sql
1 file changed, 1 insertion(+), 0 deletions(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/41/15141/1
diff --git a/backend/manager/tools/dbutils/fkvalidator_sp.sql
b/backend/manager/tools/dbutils/fkvalidator_sp.sql
index 2439098..9ce6114 100644
--- a/backend/manager/tools/dbutils/fkvalidator_sp.sql
+++ b/backend/manager/tools/dbutils/fkvalidator_sp.sql
@@ -1,6 +1,7 @@
-- Database FK validation
SET client_min_messages=ERROR;
DROP TYPE IF EXISTS fk_info_rs CASCADE;
+DROP FUNCTION IF EXISTS fn_db_validate_fks(boolean);
CREATE TYPE fk_info_rs AS
(table_name varchar, table_col varchar, fk_table_name varchar, fk_col
varchar, fk_violation varchar, fk_status integer);
CREATE OR REPLACE FUNCTION fn_db_validate_fks(v_fix_it boolean)
--
To view, visit http://gerrit.ovirt.org/15141
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic20625ed61caf8f1aaff4860c18f048402b32353
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Alex Lourie <alou...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
