Re: request feature: alter view add column (or something like) - Mailing list pgsql-hackers

From Tyler Erickson
Subject Re: request feature: alter view add column (or something like)
Date
Msg-id 47D16E29.2000004@mtu.edu
Whole thread Raw
In response to request feature: alter view add column (or something like)  (Olivier Thauvin <olivier.thauvin@aerov.jussieu.fr>)
List pgsql-hackers
I agree with Greg's suggested improvement, and would also like to see the ability to drop a column or change a
column'sdatatype.  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.<br/><br /> The 'Alter View' command introduced in 8.3 seems to be a good start, and I hope it will be expanded
toallow for adding/dropping/modifying view columns.<br /><br /> - Tyler<br /><br /> Greg Smith wrote: <blockquote
cite="mid:Pine.GSO.4.64.0803071022340.22456@westnet.com"type="cite"><pre><font><font face="Arial, Helvetica,
sans-serif">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.</font></font></pre> -- <br /> * Greg Smith <a class="moz-txt-link-abbreviated"
href="mailto:gsmith@gregsmith.com">gsmith@gregsmith.com</a><a class="moz-txt-link-freetext"
href="http://www.gregsmith.com">http://www.gregsmith.com</a>Baltimore, MD <br /><br /></blockquote><br /><br /><pre
class="moz-signature"cols="72">-- 
 
Tyler A. Erickson, Ph.D.
Research Scientist
Michigan Tech Research Institute
3600 Green Court, Suite 100
Ann Arbor, MI 48105
<a class="moz-txt-link-abbreviated" href="mailto:tyler.erickson@mtu.edu">tyler.erickson@mtu.edu</a>
<a class="moz-txt-link-abbreviated" href="http://www.mtri.org">www.mtri.org</a>
<a class="moz-txt-link-abbreviated" href="http://www.michiganview.org">www.michiganview.org</a>
</pre>

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Commitfest status
Next
From: Tom Lane
Date:
Subject: Re: Commitfest status