Re: CREATE OR REPLACE MATERIALIZED VIEW

On Thu, 10 Jan 2019 at 12:13, Tom Lane wrote: > For indivisible database objects such as functions, IMV the "or replace" > semantics (COR) is better than the "if not exists" semantics (CINE)... > > For tables, though, the tradeoffs seem pretty different... Thanks Tom, your explanation makes a lot

CREATE OR REPLACE MATERIALIZED VIEW

I've been looking over the syntax for creating various database objects: tables, views, functions, etc., and I wondered why there seem to be some discrepancies. For example, table creation syntax features [ IF NOT EXISTS ] but doesn't feature [ OR REPLACE ], function creation syntax is the inverse