Postgres Pro
Downloads
Home   >   mailing lists

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

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

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error during startup of 7.4.2 database
Next
From: "Tony and Bryn Reina"
Date:
Subject: Re: Database storage bloat