diff --git a/src-db/database/model/triggers/M_CH_VALUE_TRG2.xml b/src-db/database/model/triggers/M_CH_VALUE_TRG2.xml --- a/src-db/database/model/triggers/M_CH_VALUE_TRG2.xml +++ b/src-db/database/model/triggers/M_CH_VALUE_TRG2.xml @@ -1,6 +1,6 @@ - + NEW.m_ch_value_id + AND chv.name = NEW.name GROUP BY chv.name, chv.m_characteristic_id - HAVING count(*) > 1); + HAVING count(*) > 0); IF (v_Count > 0) THEN RAISE_APPLICATION_ERROR(-20000, '@DuplicatedChValueName@');