+16Hi.
Where does the part of the deployment gets build up?
alter table "process_task_dependency"
add constraint "c_process_task_dependency_connection_type" check ("connection_type" in (-1, 0, 1))
I have a domain connection_type that is used in 2 tables.. for some reason one table doesn't propagate the latest element in its check construction. There is a value 2 now as well. One table is going correct. The one shown here not.
Best answer by Mark Jongeling
It happens when Columns are copied using the Copy column task. This task does copy all properties and child-objects. Any generated objects are thereafter made non-generated. We shortly addressed this behavior here:
+23Hi Freddy,
From the top of my head that is during the Generate definition process. There should be a Dynamic model control procedure that creates the check constraints.
+16Hi Freddy,
From the top of my head that is during the Generate definition process. There should be a Dynamic model control procedure that creates the check constraints.
generated check constraints get copied but without the generated_by_control_proc_id, maybe that should not be done by default. Had to delete the constraint and then it generates the new constraint based on the domain info.
+23It happens when Columns are copied using the Copy column task. This task does copy all properties and child-objects. Any generated objects are thereafter made non-generated. We shortly addressed this behavior here:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.