Adding a column to a VIEW which has dependent objects.

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема Adding a column to a VIEW which has dependent objects.
Дата
Msg-id 3FFFAFCE.50005@trade-india.com
обсуждение исходный текст
Ответы Re: Adding a column to a VIEW which has dependent objects.
Список pgsql-sql
Dear PostgreSQL gurus,


How do people extend a parent view which has
lot of dependent views?

The parent view cannot be dropped because that will
require recreating a dozen of dependent views.

Is there any workaround.

Also is there an easy way of dumping the definitions
of all the dependent views of a given object. Does information_schema
helps here.


Regds
mallah.




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