Skip site navigation (1) Skip section navigation (2)

Re: exception with a temporary table

From: "Pablo Araujo" <ferarap(at)gmail(dot)com>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(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-21 07:29:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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(at)enterprisedb(dot)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
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?

In response to


pgsql-jdbc by date

Next:From: Ido M. TamirDate: 2006-11-21 09:35:40
Subject: Re: Hello World
Previous:From: AndreasDate: 2006-11-21 06:00:02
Subject: Hello World

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group