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: b8e724640611202329o69060c9as91e13f4fb9566fb2@mail.gmail.com (view raw or flat)
Thread:
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   http://www.enterprisedb.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>

In response to

Responses

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-2014 The PostgreSQL Global Development Group