max_expr_depth

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: max_expr_depth
Date: 2001-06-19 00:50:49
Message-ID: 3B2EA1E9.843D940A@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I recently tried to do a big update with postgres 7.1.2. The update was
something like
UPDATE table SET status = 2 WHERE id IN (a few thousand entries) AND
status = 1;

and I got:
ERROR: Expression too complex: nesting depth exceeds max_expr_depth =
10000

What exactly caused this and how do I work around it?

--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-06-19 00:59:47 Re: max_expr_depth
Previous Message Philip Hallstrom 2001-06-18 23:31:28 Re: aggregate function for median calculation