Postgres Pro
Downloads
Home   >   mailing lists

Re: infinite recursion detected in rules for relation "..." - Mailing list pgsql-general

From Tom Lane
Subject Re: infinite recursion detected in rules for relation "..."
Date
Msg-id 22867.1100973676@sss.pgh.pa.us
Whole thread Raw
In response to infinite recursion detected in rules for relation "..."  (Sebastian Böck <sebastianboeck@freenet.de>)
Responses Re: infinite recursion detected in rules for relation "..."
List pgsql-general
Tree view 
=?ISO-8859-1?Q?Sebastian_B=F6ck?= <sebastianboeck@freenet.de> writes:
> infinite recursion detected in rules for relation "..."

If you need a patch immediately, here it is.

*** src/backend/rewrite/rewriteHandler.c.orig    Sat Nov  6 12:46:35 2004
--- src/backend/rewrite/rewriteHandler.c    Sat Nov 20 12:47:21 2004
***************
*** 1267,1272 ****
--- 1267,1274 ----
                      newstuff = RewriteQuery(pt, rewrite_events);
                      rewritten = list_concat(rewritten, newstuff);
                  }
+
+                 rewrite_events = list_delete_first(rewrite_events);
              }
          }


            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: phpPgAdmin problem - this list?
Next
From: Baldeep Hira
Date:
Subject: Re: Error dropping non-existent tables