matview join view error

From: "Erikjan Rijkers" <er(at)xs4all(dot)nl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: matview join view error
Date: 2013-03-10 22:51:57
Message-ID: 020d9eac9e9c306a1a75a74b61b42af4.squirrel@webmail.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2013-03-11 00:02:13 Re: Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]
Previous Message Tom Lane 2013-03-10 22:01:59 Re: [v9.3] writable foreign tables