2017-04-07 13:06 GMT-03:00 Kevin Grittner <kgri...@gmail.com>: > ERROR: cannot drop table t1 column t1id because other objects depend on it > DETAIL: view v1 depends on table t1 column t1id > HINT: Use DROP ... CASCADE to drop the dependent objects too. > > Is that comment wrong? >
Sort of. If you consider ALTER TABLE ... DROP COLUMN ... CASCADE, it is not that wrong. However, if you want to be strict, there should be a check to identify a table column and then hint a specific message (ALTER instead of DROP). -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento <http://www.timbira.com.br>
