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



Sat, 29 May 2004 02:13:30 +0200
Gaetano Mendola <mendola@bigfoot.com>
false infinite recursion detected
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

Sat, 29 May 2004 01:55:49 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: false infinite recursion detected 
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




Sat, 29 May 2004 18:20:57 +0200
Gaetano Mendola <mendola@bigfoot.com>
Re: false infinite recursion detected