Re: Implementing IF NOT EXISTS clause for all CREATE TYPE variants

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Bram Hagens <bram@bramh.me>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-10-12T17:59:27Z
Lists: pgsql-hackers
On Sun, Oct 12, 2025 at 1:45 PM Bram Hagens <bram@bramh.me> wrote:

> I don't see an immediate reason why this has not been implemented, and
> also did
> not find anything on the mailing list archives. I would like to try my
> hand at
> implementing this. As this would be my first contribution, I would like to
> discuss what changes would have to be made.
>

The following thread provides some history relevant to this kind of patch:

https://www.postgresql.org/message-id/flat/903090.1648773031%40sss.pgh.pa.us#93e40bfc6f1c0aed9b1d8e5072cc04c2

I tend to fall into the camp of allowing these tools and expecting users to
utilize them properly.

David J.