Re: exception with a temporary table

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Pablo Araujo" <ferarap(at)gmail(dot)com>
Cc: "Dave Cramer" <pg(at)fastcrypt(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: exception with a temporary table
Date: 2006-11-20 16:15:38
Message-ID: 4561D4AA.6090705@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Pablo Araujo wrote:
> I think that the problem is in "on commit drop", because i excecute this
> statment in the query browse of pgAdmin III and happens the same, What I
> must modify?

Yep. I don't know where the create table statement is coming from;
Hibernate, AndroMDA or your application code, but apparently it needs to
be changed to "on commit delete rows".

Or maybe you're supposed to be running the statements as a single
transaction, but you're not?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Danny Milosavljevic 2006-11-20 17:13:34 XA support (distributed transactions)
Previous Message Pablo Araujo 2006-11-20 15:12:19 Re: exception with a temporary table