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
