> On 2 Jul 2024, at 03:22, Erik Wienhold <e...@ewie.name> wrote: > Patch 0002 deprecates CREATE MATERIALIZED VIEW IF NOT EXISTS because it > no longer seems necessary with patch 0001. Tom Lane commented[1] about > the general dislike of IF NOT EXISTS, to which I agree, but maybe this > was meant only in response to adding new commands. Anyway, my idea is > to deprecate that usage in PG18 and eventually remove it in PG19, if > there's consensus for it.
Considering the runway we typically give for deprecations, that seems like a fairly short timeframe for a SQL level command which isn't unlikely to exist in application code. -- Daniel Gustafsson