Re: [ADMIN] idle in transaction with mod_perl

2002-10-04 Thread Andrew Sullivan
On Fri, Oct 04, 2002 at 08:04:37PM +0530, [EMAIL PROTECTED] wrote: > I too use mod_perl + postgresql > its perfectly ok to have "idle in transaction..." Well, not really. But it's probably normal. See below. > the persistant connections makes all the difference. For some reason, most of the p

Re: [ADMIN] idle in transaction with mod_perl

2002-10-04 Thread mallah
Hey Kotis! I too use mod_perl + postgresql its perfectly ok to have "idle in transaction..." Becoz as soon as DBI -> commits a given transaction the mod_perl process starts a new transaction. the $dbhs' are in a perpetual transaction mode. I gues you must have done DBI->{AutoCommit} = 0 fo

[ADMIN] idle in transaction with mod_perl

2002-10-04 Thread Kostis
Hi all. Let me start by saying that I've been using postgres 7.1.3 since it came out and have found it to be rock solid and simply wonderful! :-) I particularly like the unlimited size varchars which I was waiting like crazy for. ( actually i think they came out in a previous release which i m