Re: [HACKERS] matview join view error

2013-03-14 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: Erikjan Rijkers e...@xs4all.nl 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

Re: [HACKERS] matview join view error

2013-03-13 Thread Kevin Grittner
Erikjan Rijkers e...@xs4all.nl 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:

Re: [HACKERS] matview join view error

2013-03-11 Thread Tom Lane
Erikjan Rijkers e...@xs4all.nl 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

[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