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