Re: [Postgres-xc-developers] Clarification on materialized view restriction needed

[Ashutosh B. <ash...@en...>]

Sorry, wrong mailing list. It should have been pgsql-hackers. Ignore this
mail.



On Tue, Aug 27, 2013 at 12:45 PM, Ashutosh Bapat <
ash...@en...> wrote:

> Hi All,
> I want to create a materialized view as the output of a plpgsql function
> returning a set of rows. But that function creates temporary tables and
> thus can not be used for creating materialized view as per the
> documentation at
> http://www.postgresql.org/docs/9.3/static/sql-creatematerializedview.html.
> "This query will run within a security-restricted operation; in
> particular, calls to functions that themselves create temporary tables will
> fail."
>
> I tried to understand what is "security-restricted operation", and didn't
> find any definition of this term or any listing as to "these are
> security-restricted operations ...". I am wondering what are other
> restrictions on the queries whose results can be used to create
> materialized views.
>
> --
> Best Wishes,
> Ashutosh Bapat
> EntepriseDB Corporation
> The Postgres Database Company
>



-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Postgres Database Company