How can I get list of views that are using given column in table?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема How can I get list of views that are using given column in table?
Дата
Msg-id 20120220120653.GA21922@depesz.com
обсуждение исходный текст
Ответы Re: How can I get list of views that are using given column in table?  (Thom Brown <thom@linux.com>)
Список pgsql-general
hi
I have situation, where I need to change datatype of column.
But when I do:
alter table xx alter column yy type zz;
i get error:
ERROR:  cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view some_view depends on column "yy"

how can I get a list of all such views (in a sqlish way, so I could make a
query to return all needed objects that need to be dropped/recreated).

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

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

Предыдущее
От: Venkat Balaji
Дата:
Сообщение: Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue
Следующее
От: Thom Brown
Дата:
Сообщение: Re: How can I get list of views that are using given column in table?