| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Vegard Munthe <vegard(at)copyleft(dot)no> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: RULE and more than 10 rewrites. |
| Date: | 2003-01-22 21:40:29 |
| Message-ID: | 24403.1043271629@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Vegard Munthe <vegard(at)copyleft(dot)no> writes:
> I have a RULE that does 18 rewrites. This is a RULE that saves me alot of
> work when rewriting some software, but the RULE always fails since PGSQL
> seems tp think 10 or more rewrites constitutes a loop.
> "ERROR: query rewritten 10 times, may contain cycles"
> Is there any way I can set the rewrite limit to more than 10, say 100,
> which would be more of a safeguard number for loops?
Well, you could alter the value by hand in src/backend/rewrite/rewriteHandler.c
... or you could upgrade to 7.3, wherein the default limit is 100.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Björn Metzdorf | 2003-01-22 21:43:05 | Re: sort by relevance |
| Previous Message | Greg Copeland | 2003-01-22 20:59:53 | Re: [HACKERS] C++ coding assistance request for a visualisation |