Hi,
Sometimes we create a domain manually. For a quick fix.
However, the 020_upgrade script does not check if the domain already exists.
So, SF outputs something like:
/* Create domain T_bl_claus2 */
create type T_bl_claus2 from nvarchar(250) grant references on type::T_bl_claus2 to public go
Can this be wrapped with an 'IF NOT EXISTS’’?
Does not happen often, but sometimes the deployment breaks on it, which is some work to fix.
I think something similar happened when a deployment failed. Some constraints were already dropped. However, the script stopped because it couldn't find a constraint to drop. I manually created the constraint, and the script ran fine. A check for an IF EXISTS would be nice.
Thanks
Blommetje