Re: [PATCH] rename column if exists

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: David Oksman <oksman(dot)dav(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] rename column if exists
Date: 2021-11-04 10:46:21
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> 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.

Daniel Gustafsson

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2021-11-04 10:55:22 Re: [PATCH] More docs on what to do and not do in extension code
Previous Message Daniel Gustafsson 2021-11-04 10:36:45 Re: Printing backtrace of postgres processes