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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sean Shanny <shannyconsulting(at)earthlink(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Out of memory error when doing an update with IN clause
Date: 2003-12-29 16:49:56
Message-ID: 15500.1072716596@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sean Shanny <shannyconsulting(at)earthlink(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-12-29 16:57:35 Re: An out of memory error when doing a vacuum full
Previous Message Tom Lane 2003-12-29 16:45:04 Re: An out of memory error when doing a vacuum full