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

Started by Olivier Thauvinalmost 18 years ago1 messages
#1Olivier Thauvin
olivier.thauvin@aerov.jussieu.fr

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.