Re: Out of memory error when doing an update with IN clause

Sean Shanny <shannyconsulting@earthlink.net> writes:
> update f_commerce_impressions set servlet_key = 60 where servlet_key in
> (68,69,70,71,87,90,94,91,98,105,106);
> ERROR:  out of memory

How many rows will this try to update?  Do you have any triggers or
foreign keys in this table?  I'm wondering if the list of pending
trigger events could be the problem ...

            regards, tom lane