Alter column with views depended on it without drop views

Поиск
Список
Период
Сортировка
От Emi Lu
Тема Alter column with views depended on it without drop views
Дата
Msg-id 5329A94E.1020902@encs.concordia.ca
обсуждение исходный текст
Ответы Re: Alter column with views depended on it without drop views
Список pgsql-general
Hello list,

Is there a way to change a table column from varchar(n) to varchar with
views depended on it.

The problem is that I do not want to drop and re-create all views
dependencies. I am looking for a way/command that can change the column
type and all views will be auto updated as well.

Thanks a lot!
Emi
--
PostgreSQL 8.3.18 on x86_64-unknown-linux-gnu


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