having to do with machinery: a mechanical failure. 2. being a machine; operated by machinery: a mechanical toy. 3. caused by or derived from machinery: mechanical propulsion.
ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view v_change_me depends on column too_short. Though PostgreSQL tells us which view and column prompted this error, thatâs the last favor it provides.
A rule can be created only in the current database. After you create a rule, execute sp_bindrule to bind the rule to a column or to alias data type. A rule must be compatible with the column data type. For example, @value LIKE A% cannot be used as a rule for a numeric column. A rule cannot be bound to a text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml, CLR user-defined type, or timestampcolumn.