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
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 |