| From: | Rod Taylor <rbt(at)zort(dot)ca> |
|---|---|
| To: | Hannu Krosing <hannu(at)tm(dot)ee> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Temporary Views |
| Date: | 2002-08-13 19:10:09 |
| Message-ID: | 1029265810.74400.105.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > that TODO item was written before we had dependencies, and I think
> > it's obsolete. Basically the point of the TODO was to avoid
> > having broken views --- and we have solved that problem.
>
> We may have broken views again when "alter table drop column" gets done
Any view depending on a column which is dropped should also be removed
via the dependency code. Views won't break but you can't drop a column
that is used in a view without specifying cascade.
This is a case where create or replace view is useful. Change the view
definition to no longer be dependent on the object you wish to drop.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-08-13 19:30:48 | Re: Temporary Views |
| Previous Message | Bruce Momjian | 2002-08-13 19:03:21 | Re: db partial dumping with pg_dump |