Change definition of a view

Поиск
Список
Период
Сортировка
От Andreas Roth
Тема Change definition of a view
Дата
Msg-id 200602091811.24476.aroth@arsoft-online.com
обсуждение исходный текст
Ответы Re: Change definition of a view
Список pgsql-sql
Hello,

one question: Is it possible to add or remove a column from a view without 
drop the view and recreate it?

If one or more rules depend on a view, it's very hard to extend a view. 
I use the following procedure to extend a view:
- drop depending rules
- drop view
- recreate view with additional column
- recreate all rules

Any help is welcomed!

Thanks,
Andreas Roth


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

Предыдущее
От: "BigSmoke"
Дата:
Сообщение: Re: unique constraint instead of primary key? what disadvantage(ODBC usage)?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: unique constraint instead of primary key? what disadvantage(ODBC usage)?