Re: Temporary Views

Поиск
Список
Период
Сортировка
Искать
От
Rod Taylor
Тема
Re: Temporary Views
Дата
Msg-id
1029265810.74400.105.camel@jester
Ответ на
Re: Temporary Views (Hannu Krosing)
Список
Дерево обсуждения
Temporary Views Gavin Sherry <swm@linuxworld.com.au>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Tom Lane <tgl@sss.pgh.pa.us>
Re: Temporary Views Rod Taylor <rbt@zort.ca>
Re: Temporary Views Tom Lane <tgl@sss.pgh.pa.us>
Re: Temporary Views Rod Taylor <rbt@zort.ca>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Rod Taylor <rbt@zort.ca>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Tom Lane <tgl@sss.pgh.pa.us>
Re: Temporary Views Hannu Krosing <hannu@tm.ee>
Re: Temporary Views Rod Taylor <rbt@zort.ca>
Re: Temporary Views Hannu Krosing <hannu@tm.ee>
Re: Temporary Views Hannu Krosing <hannu@tm.ee>
Re: Temporary Views Tom Lane <tgl@sss.pgh.pa.us>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Tom Lane <tgl@sss.pgh.pa.us>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Tom Lane <tgl@sss.pgh.pa.us>
Re: Temporary Views Hannu Krosing <hannu@tm.ee>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Tom Lane <tgl@sss.pgh.pa.us>
Re: Temporary Views Gavin Sherry <swm@linuxworld.com.au>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Gavin Sherry <swm@linuxworld.com.au>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Tom Lane <tgl@sss.pgh.pa.us>
Re: Temporary Views Hannu Krosing <hannu@tm.ee>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Tom Lane <tgl@sss.pgh.pa.us>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Tom Lane <tgl@sss.pgh.pa.us>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Temporary Views Tom Lane <tgl@sss.pgh.pa.us>
Re: Temporary Views Bruce Momjian <pgman@candle.pha.pa.us>
> > 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.



В списке pgsql-hackers по дате отправления
От: Bruce Momjian
Дата:
От: Hannu Krosing
Дата:
FAQ