Re: [HACKERS] matview join view error

2013-03-14 Thread Kevin Grittner
Tom Lane wrote: > "Erikjan Rijkers" writes: >> With 9.3devel, I can't seem to join a matview to a view; surely >> that should be allowed? > > Fixed, thanks for the report. Thanks for the fix while I was away. Regression test for this case added. -- Kevin Grittner EnterpriseDB: http://www.enter

Re: [HACKERS] matview join view error

2013-03-13 Thread Kevin Grittner
Erikjan Rijkers wrote: > With 9.3devel, I can't seem to join a matview to a view; surely > that should be allowed? Yes. > Here is an example: I expect to add a regression test based on that, once the bug is fixed. Thanks! -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterp

Re: [HACKERS] matview join view error

2013-03-11 Thread Tom Lane
"Erikjan Rijkers" writes: > With 9.3devel, I can't seem to join a matview to a view; surely that should > be allowed? Fixed, thanks for the report. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscrip

[HACKERS] matview join view error

2013-03-10 Thread Erikjan Rijkers
With 9.3devel, I can't seem to join a matview to a view; surely that should be allowed? Here is an example: -8<-- #!/bin/sh echo " drop table if exists t1 cascade; drop table if exists t2 cascade; drop materialized view if exists mv ; create table t1 as select chr(i) as c1, i from g