Re: exception with a temporary table - Mailing list pgsql-jdbc

From Pablo Araujo
Subject Re: exception with a temporary table
Date
Msg-id b8e724640611202329o69060c9as91e13f4fb9566fb2@mail.gmail.com
Whole thread Raw
In response to Re: exception with a temporary table  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-jdbc
Yes I suppose that the statment is running as a single transaction, but,  why is running it with MySQL?
I think that it must have a property in hibernate or postgresql, about who can be indicated this type of things.
 
What do you think about this?

 
2006/11/20, Heikki Linnakangas <heikki@enterprisedb.com>:
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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Is UTF-8 required for PostgreSQL JDBC?
Next
From: Albert Cardona
Date:
Subject: Re: Hello World