From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | Ryan Mahoney <ryan(at)paymentalliance(dot)net> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: max_expr_depth |
Date: | 2001-06-19 01:15:55 |
Message-ID: | 3B2EA7CB.D4B35124@selectacast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The idea was to improve performance by buffering a bunch of single
updates and doing a big update .. where in(list).
I surmised that it was my in() that was causing the problem, but I
wanted to know exactly what the problem was and how big I can make my
IN().
Ryan Mahoney wrote:
>
> I don't know the cause, but if you only have to run this procedure once in
> a while, you could select all the records that need to be updated, and use
> a text editor to build a few thousand single update statement, then save
> this file and echo it to the postgres backend through psql.
>
> Good Luck!
>
> -r
>
> At 08:50 PM 6/18/01 -0400, Joseph Shraibman wrote:
>
> >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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2001-06-19 01:35:28 | Error: RelationBuildTriggers: 2 record(s) not found for rel customerinfo |
Previous Message | Doug McNaught | 2001-06-19 00:59:47 | Re: max_expr_depth |