Re: ERROR: cannot change name of view column - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: ERROR: cannot change name of view column
Date
Msg-id CAKFQuwZo8hdW8E=Vow0qw_qe+gcRKo+Zn3ecXrCxAnHkYAA_LQ@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: cannot change name of view column  (Réal A. Carbonneau <contact@realcarbonneau.com>)
Responses Re: ERROR: cannot change name of view column  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Tuesday, January 1, 2019, Réal A. Carbonneau <contact@realcarbonneau.com> wrote:
Since CREATE ... OR REPLACE  is literally: "if exists, drop and create, else, create",

It’s specifically saying “replace the query used for the view without changing the view signature/type”.  Same goes for create or replace function.  The point being the signature is public and cannot be changed on the fly but the implementation can be replaced.

David J.

pgsql-bugs by date:

Previous
From: Réal A. Carbonneau
Date:
Subject: Re: ERROR: cannot change name of view column
Next
From: Tom Lane
Date:
Subject: Re: ERROR: cannot change name of view column