Re: infinite recursion detected in rules for relation "..."

#1

=?ISO-8859-1?Q?Sebastian_B=F6ck?= <sebastianboeck (AT) freenet (DOT) de> writes:

Quote:

i have a problem migrating my application from version
7.4 to 8.0. Everything is fine in 7.4 but with 8.0 i get
the following error:
infinite recursion detected in rules for relation "..."

I don't know wether its a bug or a "feature".

It's a bug. Thanks for the report.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

#2

=?ISO-8859-1?Q?Sebastian_B=F6ck?= <sebastianboeck (AT) freenet (DOT) de> writes:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: infinite recursion detected in rules for relation "..."

comp.databases.postgresql.general comp.databases.postgresql.general

Re: infinite recursion detected in rules for relation "..." - 11-20-2004 , 10:44 AM

Re: infinite recursion detected in rules for relation "..." - 11-20-2004 , 12:01 PM