Stephen Frost <sfrost(at)snowman(dot)net> writes:
> Does using table recreate break views built against the table?

Right now it just rejects the ALTER attempt:

regression=# create table t1 (f1 int);
CREATE TABLE
regression=# create view v1 as select * from t1;
CREATE VIEW
regression=# alter table t1 alter f1 type bigint;
ERROR:  cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view v1 depends on column "f1"
regression=#

Improving this per the previous discussion probably ought to be
mentioned in the TODO list.

			regards, tom lane

In response to

• Re: ALTER TABLE TODO items at 2004-05-05 15:30:36 from Stephen Frost

Responses

• Re: ALTER TABLE TODO items at 2004-05-05 16:53:41 from Bruce Momjian

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 2004-05-05 16:53:41
	Subject: Re: ALTER TABLE TODO items
Previous:	From: Rod Taylor	Date: 2004-05-05 16:51:19
	Subject: Re: PostgreSQL pre-fork speedup

pgsql-committers by date

Next:	From: Bruce Momjian	Date: 2004-05-05 16:53:41
	Subject: Re: ALTER TABLE TODO items
Previous:	From: Gaetano Mendola	Date: 2004-05-05 16:38:31
	Subject: Re: ALTER TABLE TODO items