false infinite recursion detected
Hi all,
I distilled another our regression test failing:
create table test ( id integer, quota integer );
create or replace view v_test AS
select id, quota from test;
create or replace view v_v_test AS
select
t1.id,
t1.quota
from
v_test t1 join v_test t2 using ( id )
;
kalman=# select * from v_v_test;
ERROR: infinite recursion detected in rules for relation "v_test"
Regards
Gaetano Mendola
Gaetano Mendola <mendola@bigfoot.com> writes:
kalman=# select * from v_v_test;
ERROR: infinite recursion detected in rules for relation "v_test"
Fixed, thanks for the report!
regards, tom lane
Tom Lane wrote:
Gaetano Mendola <mendola@bigfoot.com> writes:
kalman=# select * from v_v_test;
ERROR: infinite recursion detected in rules for relation "v_test"
I think also my other message:
"passing a whole record...."
is a bug that shall to be fixed.
Regards
Gaetano Mendola