Re: parameter to control cycle detection

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Coby Beck" <coby101(at)bigpond(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: parameter to control cycle detection
Date: 2004-04-09 04:22:53
Message-ID: 20790.1081484573@sss.pgh.pa.us
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 ...

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tony and Bryn Reina 2004-04-09 05:09:11 Re: Database storage bloat
Previous Message Tom Lane 2004-04-09 04:00:38 Re: Error during startup of 7.4.2 database