X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3836F53789 for ; Fri, 15 Apr 2005 14:05:15 -0300 (ADT) 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 88108-03 for ; Fri, 15 Apr 2005 17:05:09 +0000 (GMT) Received: from krogh.officenet.no (cm-84.118.131.211.chello.no [84.118.131.211]) by svr1.postgresql.org (Postfix) with ESMTP id 3978F5334A for ; Fri, 15 Apr 2005 14:05:08 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by krogh.officenet.no (Postfix) with ESMTP id E20E82A1B87; Fri, 15 Apr 2005 19:05:06 +0200 (CEST) From: Andreas Joseph Krogh Organization: OfficeNet AS To: Markus Schaber Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*) Date: Fri, 15 Apr 2005 19:05:05 +0200 User-Agent: KMail/1.8.50 Cc: Andrew Sullivan , pgsql-sql@postgresql.org References: <200504141838.14705.andreak@officenet.no> <200504151826.47587.andreak@officenet.no> <425FED27.1040405@logix-tt.com> In-Reply-To: <425FED27.1040405@logix-tt.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200504151905.05987.andreak@officenet.no> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.187 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, RCVD_IN_SORBS_DUL X-Spam-Level: X-Archive-Number: 200504/230 X-Sequence-Number: 21123 On Friday 15 April 2005 18:34, Markus Schaber wrote: > Hi, Andreas, > > Andreas Joseph Krogh schrieb: > >>Could you try the latest postgresql-8.0-311.jdbcX.jar? The current > >>versions should solve the idle in transaction problem, the previous ones > >>tended to issue BEGIN; just after every COMMIT, so there's always an > >>open transaction. > > > > I could, but is it save agains a 7.4.5 version? > > Yes, it should be. I even tested 8.0-310 against a 7.2 server, and the > other way round, without any problems. Great, I will, thanks! =2D-=20 Andreas Joseph Krogh Senior Software Developer / Manager gpg public_key: http://dev.officenet.no/~andreak/public_key.asc =2D-----------------------+---------------------------------------------+ OfficeNet AS | The most difficult thing in the world is to | Hoffsveien 17 | know how to do a thing and to watch | PO. Box 425 Sk=F8yen | somebody else doing it wrong, without | 0213 Oslo | comment. | NORWAY | | Phone : +47 22 13 01 00 | | Direct: +47 22 13 10 03 | | Mobile: +47 909 56 963 | | =2D-----------------------+---------------------------------------------+