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.
Editorial / Best Answer. Only one column can have LONG data type. And that column cannot be used in WHERE clause or in ORDER BY clause. Also we cannot add primary key constraint to that column only not to the whole table, that means we will give primary key to any column in the table except the column having the long data type. If we give, we get the error ORA-02269: key column cannot be of LONG datatype. Showing Answers 1 - 5 of 5 Answers.