Re: Snapshot Materialized Views - GSoC

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Massa, Harald Armin" <chef(at)ghum(dot)de>
Cc: Pavel <baros(dot)p(at)seznam(dot)cz>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Snapshot Materialized Views - GSoC
Date: 2010-05-21 14:13:11
Message-ID: 19154.1274451191@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Massa, Harald Armin" <chef(at)ghum(dot)de> writes:
> please do not fortget the:
> create or replace MATERIALIZED VIEW
> option.

Please do. For something as complex as a table or view, CREATE OR
REPLACE is a lot more complicated than it is for simple objects like
functions. (See flamewar just a couple weeks ago about C.O.R. vs
CREATE IF NOT EXISTS for tables.) Putting this on the to-do list
for the GSOC project will just about guarantee failure. It's most
likely too large a task for a GSOC project already...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message MMK 2010-05-21 14:14:32 changed source files.
Previous Message Massa, Harald Armin 2010-05-21 14:02:48 Re: Snapshot Materialized Views - GSoC