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.
Postgres currently defines column order based on the attnum column of the pg_attribute table. The only way to change column order is either by recreating the table, or by adding columns and rotating data until you reach the desired layout. 1 Alter column workarounds 1.1 Recreate the table. 1.2 Add columns and move data.