logilab-database #1710753 [sqlserver] change_col_type should drop/recreate views like it does indices [validation pending]

On SQL Server, we create views to implement multi-column unique indices. When changing a column's type, we need to temporarily drop these views, or the ALTER COLUMN will fail:

The object 'utv_cw_foo_unique_xxxxx' is dependent on column 'cw_bar'. (5074) (SQLExecDirectW)
prioritynormal
typebug
done in1.13.4
load2.000
load left0.000
closed by#63c53029d5ef [sqlserver] drop/recreate unique_together views/indexes around changing column type
patch[sqlserver] drop/recreate unique_together views/indexes around changing column type [applied]

Workflow history

from state (3)to statecommentdateUser
donevalidation pending2015/09/28 10:32 UTCnarval
in-progressdone2015/09/28 09:48 UTC 
openin-progress2015/09/28 07:53 UTC 

Ticket #1710753 - latest update on 2015/09/28, created on 2015/09/28 by Julien Cristau