false infinite recursion detected - Mailing list pgsql-hackers

From Gaetano Mendola
Subject false infinite recursion detected
Date
Msg-id c98kjd$58l$1@floppy.pyrenet.fr
Whole thread Raw
Responses Re: false infinite recursion detected  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: passing a whole record variable into a SQL command is not implemented
Next
From: Stephan Szabo
Date:
Subject: Re: Nested xacts: looking for testers and review