Re: [HACKERS] false infinite recursion detected

2004-05-29 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> 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 -

Re: [HACKERS] false infinite recursion detected

2004-05-28 Thread Tom Lane
Gaetano Mendola <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP

[HACKERS] false infinite recursion detected

2004-05-28 Thread Gaetano Mendola
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=# sele