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

From David G. Johnston
Subject Re: [PATCH] rename column if exists
Date
Msg-id CAKFQuwZCG8sJZ-X78n1qmoE+EP7M-mjNfFvSop-VUiOcQTQRdA@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] rename column if exists  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCH] rename column if exists
List pgsql-hackers
On Friday, November 5, 2021, Tom Lane <tgl@sss.pgh.pa.us> wrote:
I'd be more willing to overlook that if a clear use-case had been
given, but AFAICS no concrete case has been offered.


The use case is the exact same one for all of these - indempotence, especially in the face of being able to run migration scripts starting at a point in the past and still having the final outcome be the same (or error if there is a fundamental conflict in the history).  It’s the same argument used for why our current implementation of create [type] if not exists is broken in how it deals with schemas.

David J.

pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: pg14 psql broke \d datname.nspname.relname
Next
From: Robert Haas
Date:
Subject: Re: should we enable log_checkpoints out of the box?