[GENERAL] How to drop column from interrelated views

Поиск
Список
Период
Сортировка
От Guyren Howe
Тема [GENERAL] How to drop column from interrelated views
Дата
Msg-id 96A60092-A248-4AFF-81C2-4C50CE86273D@gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] How to drop column from interrelated views  (Berend Tober <btober@computer.org>)
Re: [GENERAL] How to drop column from interrelated views  (pinker <pinker@onet.eu>)
Re: [GENERAL] How to drop column from interrelated views  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general
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