Joseph Shraibman <jks(at)selectacast(dot)net> writes:
> //this update causes the error
> update table2 set status = newstatus where id in (chunk[0], chunk[1]...);
Hmm. Do you have a particularly large number of indexes on that table?
Are you running a whole bunch of these operations in parallel?
regards, tom lane