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.
Answer / lakshmikanthan. while using where or order by clause in long datatype column . error will come LIKE. ORA-00997: illegal use of LONG datatype . And another points is : 1. only one long data type allowed in a table. 2. cannot able to create the constraint in a long data type column in a table. error : ORA-02269: key column cannot be of LONG datatype.