Eli Mesika has posted comments on this change. Change subject: core: Create default disk profiles for data domains ......................................................................
Patch Set 2: (1 comment) http://gerrit.ovirt.org/#/c/34598/2/packaging/dbscripts/upgrade/03_05_1120_create_default_disk_profiles.sql File packaging/dbscripts/upgrade/03_05_1120_create_default_disk_profiles.sql: Line 15: END; Line 16: $$ LANGUAGE plpgsql; Line 17: Line 18: SELECT create_default_disk_profiles(); Line 19: DROP FUNCTION create_default_disk_profiles(); no need for the SP here this should do the work : INSERT INTO disk_profiles (SELECT uuid_generate_v1(), storage_name, id, NULL, 'Default unlimited disk profile' FROM storage_domain_static WHERE storage_domain_type IN (0,1) -- 0 and 1 are data domains type AND id NOT IN (select storage_domain_id from disk_profiles)); -- To view, visit http://gerrit.ovirt.org/34598 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: I3ee3174e5c7bef3bcd5591b9cd99ff5324bee488 Gerrit-PatchSet: 2 Gerrit-Project: ovirt-engine Gerrit-Branch: ovirt-engine-3.5 Gerrit-Owner: Roy Golan <rgo...@redhat.com> Gerrit-Reviewer: Eli Mesika <emes...@redhat.com> Gerrit-Reviewer: Gilad Chaplik <gchap...@redhat.com> Gerrit-Reviewer: Roy Golan <rgo...@redhat.com> Gerrit-Reviewer: Tal Nisan <tni...@redhat.com> Gerrit-Reviewer: automat...@ovirt.org Gerrit-Reviewer: oVirt Jenkins CI Server Gerrit-HasComments: Yes _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
