pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Coby Beck <dragon.huneault@bigpond.com>
To: pgsql-admin@postgresql.org
Subject: Re: parameter to control cycle detection
Date: Fri, 9 Apr 2004 16:14:04 +1000
Message-ID: <IMEDKHPJPMPHNFLBCMOCEEEHCEAA.dragon.huneault@bigpond.com> (raw)
In-Reply-To: <20790.1081484573@sss.pgh.pa.us>

>
> "Coby Beck" <coby101@bigpond.com> writes:
> > I get the following error trying to update a view:
> > "ERROR: query rewritten 10 times, may contain cycles"
>
> Update to something newer.  The default limit is 100 in 7.3, and the
> whole thing is gone in favor of *real* loop detection in 7.4 ...

Thanks for the reply, Tom.  Upgrading is on the TODO list for sure.  In the
meantime, is there not a way to change the default?

Coby

---
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: <IMEDKHPJPMPHNFLBCMOCEEEHCEAA.dragon.huneault@bigpond.com>
Permalink:  ../IMEDKHPJPMPHNFLBCMOCEEEHCEAA.dragon.huneault@bigpond.com/
Also on:    postgresql.org/message-id/IMEDKHPJPMPHNFLBCMOCEEEHCEAA.dragon.huneault@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: dragon.huneault@bigpond.com
  Subject: Re: parameter to control cycle detection
  In-Reply-To: <IMEDKHPJPMPHNFLBCMOCEEEHCEAA.dragon.huneault@bigpond.com>
  References: <20790.1081484573@sss.pgh.pa.us> <IMEDKHPJPMPHNFLBCMOCEEEHCEAA.dragon.huneault@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