| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ALTER TABLE TODO items |
| Date: | 2004-05-05 16:52:15 |
| Message-ID: | 7488.1083775935@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-05-05 16:53:41 | Re: ALTER TABLE TODO items |
| Previous Message | Gaetano Mendola | 2004-05-05 16:38:31 | Re: ALTER TABLE TODO items |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-05-05 16:53:41 | Re: ALTER TABLE TODO items |
| Previous Message | Rod Taylor | 2004-05-05 16:51:19 | Re: PostgreSQL pre-fork speedup |