| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | stan <stanb(at)panix(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Problems modifyiong view |
| Date: | 2019-11-14 14:34:11 |
| Message-ID: | CA+FnnTx0wiiN06jR3OvDk=dBtCrUM_AN-d1wzukDMPry_isvsQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
On Thu, Nov 14, 2019 at 7:54 AM stan <stanb(at)panix(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-11-14 15:12:22 | Re: Problems modifyiong view |
| Previous Message | Adrian Klaver | 2019-11-14 14:31:48 | Re: Problems modifyiong view |