Re: Rename a column if not already renamed.?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Day, David" <david(dot)day(at)redcom(dot)com>
Cc: Luca Ferrari <fluca1978(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Rename a column if not already renamed.?
Date: 2019-08-20 20:56:46
Message-ID: 17271.1566334606@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Day, David" <david(dot)day(at)redcom(dot)com> writes:
> The error is something like column already exists and

Not sure about the workflow this function is used within, but maybe you
need to consider what to do when both the old and new column names exist.
Because that sure sounds like what is happening.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2019-08-20 20:58:21 Re: Databases and servers
Previous Message Adrian Klaver 2019-08-20 20:42:34 Re: Two Postgres master process are showing - one is on and off