Re: parameter to control cycle detection

From: "Coby Beck" <dragon(dot)huneault(at)bigpond(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: parameter to control cycle detection
Date: 2004-04-09 06:14:04
Message-ID: IMEDKHPJPMPHNFLBCMOCEEEHCEAA.dragon.huneault@bigpond.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>
> "Coby Beck" <coby101(at)bigpond(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris White (cjwhite) 2004-04-09 07:26:11 Trouble restoring 7.2.1 database into 7.4.2 database
Previous Message Tom Lane 2004-04-09 05:15:05 Re: Multiple disks