[GENERAL] How to drop column from interrelated views

Поиск
Список
Период
Сортировка
I’ve a set of interrelated views. I want to drop a column from a table and from all the views that cascade from it.

I’ve gone to the leaf dependencies and removed the field from them. But I can’t remove the field from the intermediate views because Postgres doesn’t appear to be clever enough to see that the leafs no longer depend on the column. Or did I just miss one?

In general, this seems like a major weakness expressing a model in Postgres (I get that any such weakness derives from SQL; that doesn’t stop me wanting a solution).

Thoughts? Comments?

Thanks in advance.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Zhu, Joshua"
Дата:
Сообщение: [GENERAL] BDR node removal and rejoin
Следующее
От: Berend Tober
Дата:
Сообщение: Re: [GENERAL] How to drop column from interrelated views