false infinite recursion detected

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: false infinite recursion detected
Date: 2004-05-29 00:13:30
Message-ID: c98kjd$58l$1@floppy.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2004-05-29 00:43:41 Re: Nested xacts: looking for testers and review
Previous Message Jonathan Gardner 2004-05-29 00:13:28 Re: Extended customizing, SQL functions,