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 5683252965 for ; Fri, 15 Apr 2005 13:25:17 -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 74992-02 for ; Fri, 15 Apr 2005 16:25:08 +0000 (GMT) Received: from mail.logix-tt.com (wallaby.dingens.org [212.75.36.180]) by svr1.postgresql.org (Postfix) with ESMTP id 901DD537E4 for ; Fri, 15 Apr 2005 13:25:08 -0300 (ADT) Received: from kingfisher.intern.logi-track.com (J2985.j.pppool.de [85.74.41.133]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id 27633A8616; Fri, 15 Apr 2005 18:25:10 +0200 (CEST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with ESMTP id 76DCEAB0F9; Fri, 15 Apr 2005 18:24:15 +0200 (CEST) Message-ID: <425FEAAF.1080008@logix-tt.com> Date: Fri, 15 Apr 2005 18:24:15 +0200 From: Markus Schaber Organization: Logical Tracking and Tracing International AG, Switzerland User-Agent: Mozilla Thunderbird 1.0 (X11/20050116) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: Andrew Sullivan Cc: pgsql-sql@postgresql.org Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*) References: <200504141838.14705.andreak@officenet.no> <200504141921.38476.andreak@officenet.no> <20050414173358.GB9027@phlogiston.dyndns.org> <200504141954.20520.andreak@officenet.no> <20050414185623.GC9027@phlogiston.dyndns.org> In-Reply-To: <20050414185623.GC9027@phlogiston.dyndns.org> X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-ripemd160; protocol="application/pgp-signature"; boundary="------------enig3A1A0D51CD5E4960C990B609" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.064 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/227 X-Sequence-Number: 21120 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig3A1A0D51CD5E4960C990B609 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi, Andrew, Andrew Sullivan schrieb: > Nope. That's a problem with your pool software. It's no doubt > issuing "BEGIN;" as soon as it connects. This problem may as well be caused by some versions of the postgresql jdbc driver, no need to blame the pool software. This is fixed with the current build 311 (and AFAIK with 310, too). --------------enig3A1A0D51CD5E4960C990B609 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCX+qvyHQIGEs7eeARA8MFAJ9roWUs/2Q+IexVPpH/1Qf9LgqoUQCfZwNT czM5pBUtRmNQLIYuJYLLj0o= =rOtn -----END PGP SIGNATURE----- --------------enig3A1A0D51CD5E4960C990B609--