There used to be a bug in either MySQL or SQL server (can't recall which anymore) where if you used select * in a view and then adjusted the schema the data would be out of line with the columns.
Thats not too bad, and it does not get the column names mixed up.
(Select * from ... in PostgreSQL is actually really usefun in anything object-relational because you get objects of a named type back btw.)
The columns being renamed on views bit us big time. We had a large ERP package that we'd built numerous custom views on top of. Whenever we applied an update to the ERP package, it'd add columns and all our views would be borked.