Re: [PATCH] rename column if exists

On Thursday, November 4, 2021, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:

> > On 22 Mar 2021, at 20:40, David Oksman <oksman(dot)dav(at)gmail(dot)com> wrote:
> >
> > Added the ability to specify IF EXISTS when renaming a column of an
> object (table, view, etc.).
> > For example: ALTER TABLE distributors RENAME COLUMN IF EXISTS address TO
> city;
> > If the column does not exist, a notice is issued instead of throwing an
> error.
>
> What is the intended use-case for RENAME COLUMN IF EXISTS? I'm struggling
> to
> see when that would be helpful to users but I might not be imaginative
> enough.
>
>
Same reasoning as for all the other if exists we have, idempotence. Being
able to run the command on an object that is already in the desired state
without provoking an error.

David J.