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 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 and determine where this woul

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 wrote: > On Tue, Aug 27, 2013 at 01:57:49PM +0530, Ashutosh Bapat wrote: > > I want to create

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 >

[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 http://www.postgresql.org/docs/9.3/static/sql-creatematerializedvi