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
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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 your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[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 generate_series(65, 90) as f(i);
create table t2 as select chr(i) as c2, i from generate_series(65, 90) as f(i);
create materialized view mv as select c1, i from t1 where i between 75 and 85;
create or replace view v as select c2, i from t2;
 | psql -qX

echo 
select
   m.*
 , v.*
from mv m left join v on  v.i = m.i
 | psql -qXa
-8--

This results in:

ERROR:  could not open file base/21282/15840421: No such file or directory

(15840421 is the pg_class.relfilenode of view 'v').


Thanks,

Erik Rijkers




-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers