Re: out of memory error on a delete command

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, Postgres JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: out of memory error on a delete command
Date: 2005-07-13 12:48:19
Message-ID: 1121258899.3085.196.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Maybe in theory, cause I succeeded to truncate a table which had an ON
DELETE trigger on it. I don't have time/test database ready to do more
tests now, but as soon as I'll have I'll do the same operation again
from psql to see how it behaves.

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Csaba Nagy 2005-07-13 12:50:03 Re: out of memory error on a delete command
Previous Message Oliver Jowett 2005-07-13 12:23:13 Re: out of memory error on a delete command