Yair Zaslavsky has uploaded a new change for review. Change subject: core: Fix temproaral disabling foreign keys ......................................................................
core: Fix temproaral disabling foreign keys The temporal disabling of foreign keys did not work causing upgrade to fail Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=1091227 Change-Id: I2fafc5c18bf07c5bef9805d2bfd8c4590ba226f8 Signed-off-by: Yair Zaslavsky <[email protected]> --- M packaging/dbscripts/upgrade/03_04_0730_change_group_ids.sql M packaging/dbscripts/upgrade/03_04_0740_update_user_ids.sql 2 files changed, 4 insertions(+), 4 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/85/27185/1 diff --git a/packaging/dbscripts/upgrade/03_04_0730_change_group_ids.sql b/packaging/dbscripts/upgrade/03_04_0730_change_group_ids.sql index ae6e6d5..a8b5fc2 100644 --- a/packaging/dbscripts/upgrade/03_04_0730_change_group_ids.sql +++ b/packaging/dbscripts/upgrade/03_04_0730_change_group_ids.sql @@ -16,7 +16,7 @@ substring(encode(external_id,'hex') FROM 21 FOR 12) AS uuid); --2. Changing relevant group_id appearances in other tables -ALTER TABLE tags_user_group_map DISABLE TRIGGER USER; +ALTER TABLE tags_user_group_map DISABLE TRIGGER ALL; UPDATE tags_user_group_map m set group_id = ( SELECT temp_id FROM ad_groups WHERE id = m.group_id @@ -43,7 +43,7 @@ --4. Cleanup --DROP TABLE tmp_users_group_ids; --DROP TABLE tmp_users_groups; -ALTER TABLE tags_user_group_map ENABLE TRIGGER USER; +ALTER TABLE tags_user_group_map ENABLE TRIGGER ALL; PERFORM fn_db_drop_column('ad_groups','temp_id'); RETURN; END; $procedure$ diff --git a/packaging/dbscripts/upgrade/03_04_0740_update_user_ids.sql b/packaging/dbscripts/upgrade/03_04_0740_update_user_ids.sql index 24f5974..8ea76d2 100644 --- a/packaging/dbscripts/upgrade/03_04_0740_update_user_ids.sql +++ b/packaging/dbscripts/upgrade/03_04_0740_update_user_ids.sql @@ -16,7 +16,7 @@ substring(encode(external_id,'hex') FROM 21 FOR 12) AS uuid); --2. Changing relevant group_id appearances in other tables -ALTER TABLE tags_user_map DISABLE TRIGGER USER; +ALTER TABLE tags_user_map DISABLE TRIGGER ALL; UPDATE tags_user_map m set user_id = ( SELECT temp_id FROM users WHERE user_id = m.user_id); @@ -28,7 +28,7 @@ UPDATE users SET user_id = temp_id; --3. Cleanup -ALTER TABLE tags_user_map ENABLE TRIGGER USER; +ALTER TABLE tags_user_map ENABLE TRIGGER ALL; PERFORM fn_db_drop_column('users','temp_id'); RETURN; END; $procedure$ -- To view, visit http://gerrit.ovirt.org/27185 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I2fafc5c18bf07c5bef9805d2bfd8c4590ba226f8 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: ovirt-engine-3.4 Gerrit-Owner: Yair Zaslavsky <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
