Re: Why no CREATE TEMP MATERIALIZED VIEW ?

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Ivan Voras <ivoras(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why no CREATE TEMP MATERIALIZED VIEW ?
Date: 2019-07-17 02:35:36
Message-ID: 20190717023536.GA15750@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2019-Jul-16, Ivan Voras wrote:

> Hello,
>
> Out of curiosity, since there's CREATE TEMP VIEW, any particular reason
> there's no CREATE TEMP MATERIALIZED VIEW?

Because it hasn't been implemented. There is a patch, but it's not
done. See this thread:
https://postgr.es/m/CAKLmikNoQR4ZNg_wt=-hU-uUxV2cXVdveeRsMFjr2SAopVxDxw@mail.gmail.com

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2019-07-17 03:46:11 Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems
Previous Message Alex Williams 2019-07-16 19:20:24 Re: Tablespace column value null on select * from pg_tables