Hi
This is my first post so I would like thanks for cmdbuild, great software and good work!
I have small issue:
I have created class with few attributes, one of this attribute was created with 'Mandatory' option. Few objects was created but life verified this setup and now this attribute don't need to be mandatory, so I've unchecked 'Mandatory' and got exception:
Error: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT * FROM cm_modify_attribute(?,?,?,?,?,?,?)]; SQL state [XX000]; error code [0]; ERROR: relation 18749 has non-inherited constraint "_NotNull__PowerSupplyV"
Where: SQL statement "ALTER TABLE "Boards" DROP CONSTRAINT "_NotNull__PowerSupplyV""
full details in attachment
I've imported DB into my sandbox, works like a charm and do be honest I cannot reproduce this issue
0. How can I fix this ?
1. It's safe to exec "ALTER TABLE "Boards" DROP CONSTRAINT "_NotNull__PowerSupplyV" on the DB ?
Br
Peter
cmdbuild_ex-txt (8.1 KB)