From: Coby Beck <coby101@bigpond.com>
To: pgsql-admin@postgresql.org
Subject: parameter to control cycle detection
Date: Thu, 8 Apr 2004 09:41:15 +1000
Message-ID: <IMEDKHPJPMPHNFLBCMOCOEDOCEAA.coby101@bigpond.com> (raw)
Hi,
I get the following error trying to update a view:
"ERROR: query rewritten 10 times, may contain cycles"
and it doesn't. There is a function in there legitimately called 10 times
with the same parameters. 10 seems a little low to panic about, is this
configurable? The rule code is generated programmatically so for now at
least I would like to avoid having to find a general solution for the sake
of an optimization I may not need and it is not an option to hand tweak this
one problem rule.
Can I set this 10 parameter higher somewhere?
TIA.
Coby Beck
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.639 / Virus Database: 408 - Release Date: 22/03/2004
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: coby101@bigpond.com
Subject: Re: parameter to control cycle detection
In-Reply-To: <IMEDKHPJPMPHNFLBCMOCOEDOCEAA.coby101@bigpond.com>
References: <IMEDKHPJPMPHNFLBCMOCOEDOCEAA.coby101@bigpond.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox