Hannu Krosing <[EMAIL PROTECTED]> 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 dependent objects too
regression=#
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
