Re: [PERFORM] data doesnt get saved in the database / idle in transaction

2006-03-21 Thread Jim C. Nasby
On Mon, Mar 20, 2006 at 08:03:14PM +0800, Qingqing Zhou wrote: > > ""Ksenia Marasanova"" <[EMAIL PROTECTED]> wrote > > > > The application uses persistant database connection, and when i check > > the status of the connection, it shows: "idle in transaction". I am > > pretty sure that every inser

Re: [PERFORM] data doesnt get saved in the database / idle in transaction

2006-03-20 Thread Qingqing Zhou
""Ksenia Marasanova"" <[EMAIL PROTECTED]> wrote > > The application uses persistant database connection, and when i check > the status of the connection, it shows: "idle in transaction". I am > pretty sure that every insert is being committed with explicit > "commit()" . It always worked before..

[PERFORM] data doesnt get saved in the database / idle in transaction

2006-03-20 Thread Ksenia Marasanova
Hi, I have a strange problem with my Postgres application. The problem is that the data entered in the application never reaches the database, although the record id (serial) is generated, and the record can be retrieved again, and be modified. Multiple records can be added and modified. But when