Re: BUG #2289: insert into tables not working - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: BUG #2289: insert into tables not working
Date
Msg-id 20060228153952.GA4960@winnie.fuhr.org
Whole thread Raw
In response to BUG #2289: insert into tables not working  ("Abhilash Krishnan" <abhi_742@hotmail.com>)
List 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

pgsql-bugs by date:

Previous
From: "Oleg Mamontov"
Date:
Subject: BUG #2290: Incorrect sequence increment after backup/restore
Next
From: Tom Lane
Date:
Subject: Re: BUG #2290: Incorrect sequence increment after backup/restore