Re: Problems modifyiong view - Mailing list pgsql-general

From Igor Korot
Subject Re: Problems modifyiong view
Date
Msg-id CA+FnnTx0wiiN06jR3OvDk=dBtCrUM_AN-d1wzukDMPry_isvsQ@mail.gmail.com
Whole thread Raw
In response to Problems modifyiong view  (stan <stanb@panix.com>)
List pgsql-general
Hi,

On Thu, Nov 14, 2019 at 7:54 AM stan <stanb@panix.com> 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?

What version?
What OS server is running on?
What client are you running?

Thank you.

>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
>                                                 -- Benjamin Franklin
>
>



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Problems modifyiong view
Next
From: Tom Lane
Date:
Subject: Re: Problems modifyiong view