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 по дате отправления:

Предыдущее
От: "Kumar"
Дата:
Сообщение: Re: how to show table structure?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Adding a column to a VIEW which has dependent objects.