I agree with Greg's suggested improvement, and would also like to see
the ability to drop a column or change a column's datatype. Right now
it is a pretty time consuming process to 'alter' a view (i.e. figure out
the dependent views, drop the dependent views, modify the base view, add
back the dependent views) and leaves a lot of room for human error.

The 'Alter View' command introduced in 8.3 seems to be a good start, and
I hope it will be expanded to allow for adding/dropping/modifying view
columns.

- Tyler

Greg Smith wrote:
> 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.
> --
> * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
>


--
Tyler A. Erickson, Ph.D.
Research Scientist
Michigan Tech Research Institute
3600 Green Court, Suite 100
Ann Arbor, MI 48105
tyler.erickson@mtu.edu
www.mtri.org
www.michiganview.org