Re: Temporary Views

Hannu Krosing <hannu@tm.ee> writes:
> We may have broken views again when "alter table drop column" gets done

It is done, and we do not have broken views.

regression=# create table t (f1 int, f2 int, f3 int);
CREATE TABLE
regression=# create view v as select f1,f2 from t;
CREATE VIEW
regression=# alter table t drop column f3;
ALTER TABLE
regression=# alter table t drop column f2;
NOTICE:  rule _RETURN on view v depends on table t column f2
NOTICE:  view v depends on rule _RETURN on view v
ERROR:  Cannot drop table t column f2 because other objects depend on it       Use DROP ... CASCADE to drop the
dependentobjects too
 
regression=#
        regards, tom lane