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 [EMAIL PROTECTED] 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
[EMAIL PROTECTED]
www.mtri.org
www.michiganview.org
