Eli Mesika has submitted this change and it was merged.
Change subject: core:DB upgrade from 3.0 to 3.1 fails
......................................................................
core:DB upgrade from 3.0 to 3.1 fails
Fixing the general functions that creates/drops constraint to be
case-insensitive since entity names are case-insensitive in postgres
while values are case-sensitive.
Since the 03_01_1520_add_fk_vm_interface_vm_static_template.sql tries to
insert a new constraint named FK_vm_interface_vm_static_template while
in the database there was already a fk_vm_interface_vm_static_template
constraint install, there was an attempt to install this FK again which
failed.
The solution turns the '=' operation to 'ilike' when we look for an
existing constraint by its name.
Change-Id: Id36c83154559d6062609d08068989d3ce3d2c468
Signed-off-by: Eli Mesika <emesika(a)redhat.com>
Bug-Url:https://bugzilla.redhat.com/show_bug.cgi?id=892532
---
M backend/manager/dbscripts/common_sp.sql
1 file changed, 2 insertions(+), 2 deletions(-)
Approvals:
Eli Mesika: Verified; Looks good to me, approved
--
To view, visit
http://gerrit.ovirt.org/11419
To unsubscribe, visit
http://gerrit.ovirt.org/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Id36c83154559d6062609d08068989d3ce3d2c468
Gerrit-PatchSet: 2
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com>
Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Yair Zaslavsky <yzaslavs(a)redhat.com>