Re: out of memory error on a delete command - Mailing list pgsql-jdbc

From Csaba Nagy
Subject Re: out of memory error on a delete command
Date
Msg-id 1121259003.3085.199.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: out of memory error on a delete command  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Ah, OK, I've misread your mail, so you say ignoring on delete triggers
is normal for TRUNCATE. Then all is fine with this one. I still need to
find out what have eaten the memory on that particular delete operation.

Cheers,
Csaba.


On Wed, 2005-07-13 at 14:23, Oliver Jowett wrote:
> Csaba Nagy wrote:
> > Well, I'm still at a guess what could cause the problem on the kind of
> > query I was executing (a "delete"). Kris' explanation with the deferred
> > trigger was the closest till now, except the trigger was not deferred,
> > and truncate still succeded with the "ON DELETE" trigger in place...
>
> Doesn't TRUNCATE explicitly ignore ON DELETE triggers?
>
> -O


pgsql-jdbc by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: out of memory error on a delete command
Next
From: Tom Lane
Date:
Subject: Re: out of memory error on a delete command