Re: Feature: temporary materialized views

David Steele <david@pgmasters.net>

From: David Steele <david@pgmasters.net>
To: Mitar <mmitar@gmail.com>, Andreas Karlsson <andreas@proxel.se>
Cc: Michael Paquier <michael@paquier.xyz>, Tom Lane <tgl@sss.pgh.pa.us>, Alvaro Herrera <alvherre@2ndquadrant.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2019-03-15T09:51:04Z
Lists: pgsql-hackers
On 3/15/19 3:19 AM, Mitar wrote:
> 
> On Thu, Mar 14, 2019 at 7:56 AM Andreas Karlsson <andreas@proxel.se> wrote:
>> Yeah, your patch is sadly stuck behind the refactoring, and the
>> refactoring proved to be harder to do than I initially thought. The
>> different code paths for executing CREATE MATERIALIZED VIEW are so
>> different that it is hard to find a good common interface.
>>
>> So there is unfortunately little you can do here other than wait for me
>> or someone else to do the refactoring as I cannot see your patch getting
>> accepted without keeping the existing restrictions on side effects for
>> CREATE MATERIALIZED VIEW.
> 
> Sounds good. I will wait.

This patch has been marked as Returned with Feedback since it is not 
clear when the refactoring it depends on will be done.

You can submit to a future commitfest when you are able to produce a new 
patch.

Regards,
-- 
-David
david@pgmasters.net


Commits

  1. Add more tests for CREATE TABLE AS with WITH NO DATA