Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] rename column if exists - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: [PATCH] rename column if exists
Date
Msg-id 628FE4FA-01E1-4C6C-8061-343B920AF19E@yesql.se
Whole thread Raw
In response to [PATCH] rename column if exists  (David Oksman <oksman.dav@gmail.com>)
Responses Re: [PATCH] rename column if exists
List pgsql-hackers
Tree view 
> On 22 Mar 2021, at 20:40, David Oksman <oksman.dav@gmail.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.

--
Daniel Gustafsson        https://vmware.com/

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Printing backtrace of postgres processes
Next
From: Daniel Gustafsson
Date:
Subject: Re: [PATCH] More docs on what to do and not do in extension code