On 2013-02-20 17:25:41 +0100, Misa Simic wrote:
> Hi,
>
> If we want to "add new column" to the view - the only one way (we have
> found) is:
>
> -drop view
> -create it again ( with new column )
Since 8.4 you can add new columns to the end of a view definition using
CREATE OR REPLACE VIEW.
htt
Hi,
If we want to "add new column" to the view - the only one way (we have
found) is:
-drop view
-create it again ( with new column )
Now, if some other view depends on the view we want change - it will not
allow us to drop the view - what is fine, of course - but it does not allow
us to change
