request feature: alter view add column (or something like)

Поиск
Список
Период
Сортировка
От Olivier Thauvin
Тема request feature: alter view add column (or something like)
Дата
Msg-id 200802291735.03564.olivier.thauvin@aerov.jussieu.fr
обсуждение исходный текст
Список pgsql-hackers
Sometimes, I have to add column to table, then adding the column to some view.

Currently it impossible to alter a view to add a new column, which is really
annoying. The only solution is to drop the view, and all dependented view,
then recreating everything.

Someone on #postgresqlfr said me there were discussion about that.

I think this would be a big improvement for pg 8.4.

My 2 cents.

Regards.

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

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: Why we panic in pglz_decompress
Следующее
От: Justin
Дата:
Сообщение: creating new aggregate function