pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (4+ messages)  latest in thread

Message-ID: <IMEDKHPJPMPHNFLBCMOCOEDOCEAA.coby101@bigpond.com>
Permalink:  ../IMEDKHPJPMPHNFLBCMOCOEDOCEAA.coby101@bigpond.com/
Also on:    postgresql.org/message-id/IMEDKHPJPMPHNFLBCMOCOEDOCEAA.coby101@bigpond.com

 · 

reply

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