Tom Lane wrote:
> Joseph Shraibman <jks@selectacast.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?
>
I have 3 indexes on the table, and I do this operation in a cron job once a day, not in
parallel.