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
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 |