The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Updated Views

Hi All
I have an issue in the views when i trying to do an updated in one view. My wish is include two columns more in one view but is too impossible and the data point send me error.
Thanks in advanced
Tagged:
0
Answers
@miiclaudia : you cannot update the view. you need to drop it and recreate view by adding 2 columns that you want to add.
Can't you do a CREATE OR REPLACE VIEW?
Dear Jim, the case is not permit include the new two fields in Create or replace view. =(
@miiclaudia - Not sure what you mean. Do you not have the database privileges to run a CREATE OR REPLACE VIEW?