Re: Feature: temporary materialized views - Mailing list pgsql-hackers

From Mitar
Subject Re: Feature: temporary materialized views
Date
Msg-id CAKLmikO9WY5Rf3NG=nGicq4mm_up6EymMrbU5CiR+YNaP0voWw@mail.gmail.com
Whole thread Raw
In response to Re: Feature: temporary materialized views  (Andreas Karlsson <andreas@proxel.se>)
List pgsql-hackers
Hi!

On Thu, Jan 17, 2019 at 9:53 AM Andreas Karlsson <andreas@proxel.se> wrote:
> > What is the stumbling block to just leaving that alone?
>
> I think the issue Mitar ran into is that the temporary materialized view
> is created in the rStartup callback of the receiver which happens after
> SECURITY_RESTRICTED_OPERATION is set in ExecCreateTableAs(), so the
> creation of the view itself is denied.

Yes, the error without that change is:

ERROR:  cannot create temporary table within security-restricted operation


Mitar

-- 
http://mitar.tnode.com/
https://twitter.com/mitar_m


pgsql-hackers by date:

Previous
From: Haribabu Kommi
Date:
Subject: Re: [HACKERS] Block level parallel vacuum
Next
From: Mitar
Date:
Subject: Re: Feature: temporary materialized views