Re: parameter to control cycle detection - Mailing list pgsql-admin

From Coby Beck
Subject Re: parameter to control cycle detection
Date
Msg-id IMEDKHPJPMPHNFLBCMOCEEEHCEAA.dragon.huneault@bigpond.com
Whole thread Raw
In response to Re: parameter to control cycle detection  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: parameter to control cycle detection  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
>
> "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


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multiple disks
Next
From: "Chris White (cjwhite)"
Date:
Subject: Trouble restoring 7.2.1 database into 7.4.2 database