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.