dependencies between objects

Поиск
Список
Период
Сортировка
Искать
От
Toni Casueps
Тема
dependencies between objects
Дата
Msg-id
BAY108-F2278294217F396C7469AF6AD0A0@phx.gbl
Список
Дерево обсуждения
dependencies between objects "Toni Casueps" <casueps@hotmail.com>
Re: dependencies between objects Richard Huxton <dev@archonet.com>
I have got some views (for example view B) that use another views (for 
example view A) in the FROM clause.

If I want to change view A, and it doesn't allow me to (for example adding a 
new column), another way would be dropping A and recreating it with the new 
column, but it doesn't allow me to drop view A because B depends on it, nor 
overwriting A with the new one because it already exists. One thing I can do 
is rename A to A_ , create the new A and drop A_ but it automatically 
reassociates B to depend on A_ , not in the new A I just created.

Is there a way to disable any of these restrictions?


В списке pgsql-general по дате отправления
От: Juan Jose Comellas
Дата:
От: Richard Huxton
Дата:
FAQ