X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DF6523A4278 for ; Tue, 26 Oct 2004 02:36:34 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53471-10 for ; Tue, 26 Oct 2004 01:36:22 +0000 (GMT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id 956553A1D91 for ; Tue, 26 Oct 2004 02:36:24 +0100 (BST) Received: (qmail 28587 invoked from network); 26 Oct 2004 01:36:21 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 26 Oct 2004 01:36:21 -0000 From: "Greg Sabino Mullane" To: pgsql-admin@postgresql.org Cc: mallah@trade-india.com Cc: mallah@trade-india.com Subject: Re: ' in transaction' problem in mod_perl/DBI/DBD-Pg environment. X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <417C912E.3080109@trade-india.com> Date: Tue, 26 Oct 2004 01:36:21 -0000 X-Mailer: JoyMail 1.48 Message-ID: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200410/342 X-Sequence-Number: 15335 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > Are there some precuation to be taken in perl/DBI programming > in mod_perl environment to avoid backends getting into ' in > transaction' mode? If you are not using the latest version of DBD::Pg (1.32), then you may be experiencing the problem where the "AutoCommit" setting causes "execute->commit->begin->wait." This is fixed in 1.32: it now does "begin->execute->commit->wait". - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200410252136 -----BEGIN PGP SIGNATURE----- iD8DBQFBfapWvJuQZxSWSsgRAn/aAJsFNzN1ru5GpjTL30iM1Oj2EXQ9/QCfTFYa LxQN3UVonFcFpKYEkf0ypog= =Hc+B -----END PGP SIGNATURE-----