Re: BUG #2289: insert into tables not working

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Abhilash Krishnan <abhi_742(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2289: insert into tables not working
Date: 2006-02-28 15:39:52
Message-ID: 20060228153952.GA4960@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Feb 28, 2006 at 09:24:35AM +0000, Abhilash Krishnan wrote:
> I am having an application using java, jsp, struts and hibernate with a
> backend of postgresql. Here, during some operations, although the insert
> query is generated by hibernate and can be seen in the console, the data is
> not getting inserted into the database. Any idea why it happens ?

Did you commit the transaction that performed the insert? The
effects of a transaction's operations aren't visible to other
transactions until the transaction commits. Also, if a transaction
encounters an error its operations will be rolled back unless you
protect them with savepoints.

--
Michael Fuhr

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-02-28 15:57:46 Re: BUG #2290: Incorrect sequence increment after backup/restore
Previous Message Oleg Mamontov 2006-02-28 12:43:49 BUG #2290: Incorrect sequence increment after backup/restore