Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE OR REPLACE MATERIALIZED VIEW - Mailing list pgsql-general

From Aidan Samuel
Subject Re: CREATE OR REPLACE MATERIALIZED VIEW
Date
Msg-id CAAWhf=N8=G3661QdhLG+L-+TureGrnw_GDD2e4Y3Upm-CHsq9g@mail.gmail.com
Whole thread Raw
In response to Re: CREATE OR REPLACE MATERIALIZED VIEW  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
On Thu, 10 Jan 2019 at 12:13, Tom Lane <tgl@sss.pgh.pa.us> 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 of sense.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE OR REPLACE MATERIALIZED VIEW
Next
From: Willy-Bas Loos
Date:
Subject: log level of "drop cascade" lists