Re: Problems modifyiong view

On 11/14/19 5:53 AM, stan wrote:
> I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
> getting the following error:
> 
> ERROR:  cannot change name of view column "descrip" to "contact_person_1"
> 
> I suppose  I can drop the view, and recreate it, but that seems to indicate
> that the create or replace functionality is not functioning the way I would
> expect.
> 
> Am I missing something here?
> 

https://www.postgresql.org/docs/11/sql-createview.html

"CREATE OR REPLACE VIEW is similar, but if a view of the same name 
already exists, it is replaced. The new query must generate the same 
columns that were generated by the existing view query (that is, the 
same column names in the same order and with the same data types), but 
it may add additional columns to the end of the list. The calculations 
giving rise to the output columns may be completely different."



-- 
Adrian Klaver
adrian.klaver@aklaver.com