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
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 |