Re: [HACKERS] Clarification on materialized view restriction needed

2013-08-28 Thread Robert Haas
On Wed, Aug 28, 2013 at 1:40 AM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: I would be good, if this set gets documented, lest users will be confused. Can you point me to relevant sections of document? I can add this documentation. I think it's your job to look at the documentation

[HACKERS] Clarification on materialized view restriction needed

2013-08-27 Thread Ashutosh Bapat
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

Re: [HACKERS] Clarification on materialized view restriction needed

2013-08-27 Thread Noah Misch
On Tue, Aug 27, 2013 at 01:57:49PM +0530, Ashutosh Bapat wrote: 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

Re: [HACKERS] Clarification on materialized view restriction needed

2013-08-27 Thread Ashutosh Bapat
I would be good, if this set gets documented, lest users will be confused. Can you point me to relevant sections of document? I can add this documentation. On Wed, Aug 28, 2013 at 10:12 AM, Noah Misch n...@leadboat.com wrote: On Tue, Aug 27, 2013 at 01:57:49PM +0530, Ashutosh Bapat wrote: I