what is: idle in transaction

From: "Peter J(dot) Schoenster" <borg(at)errorcode(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: what is: idle in transaction
Date: 2001-05-03 16:39:49
Message-ID: 3AF13575.24482.56134B2@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I have an app originally written to use mysql and I've switched to
postgresql as I want to use commit/rollback ... and in my tests all
is working well.

I've got a bunch of these when I run ps ax (about same amount of
both about 7/8 instances):

> postgres: admin igo [local] idle
> postgres: admin igo [local] idle in transaction

and I don't know why. I did some searching in the archives but I
didn't find anything. Could someone point me to the documentation
that speaks of this? I'm using RH 6.2 with psql (PostgreSQL) 7.1

Thanks,

Peter

---------------------------
"Reality is that which, when you stop believing in it, doesn't go
away".
-- Philip K. Dick

Browse pgsql-novice by date

  From Date Subject
Next Message Joel Burton 2001-05-03 18:46:45 Re: input from a file
Previous Message Stephen M. Ford 2001-05-03 16:29:07 input from a file