X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 959FBD8DAF; Tue, 13 Sep 2005 20:00:46 -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 02446-05; Tue, 13 Sep 2005 23:00:43 +0000 (GMT) Received: from yass.opencloud.co.nz (yass.opencloud.co.nz [203.79.85.162]) by svr1.postgresql.org (Postfix) with ESMTP id 899BFD8DBF; Tue, 13 Sep 2005 20:00:42 -0300 (ADT) Received: from 203-79-104-60.cable.paradise.net.nz ([203.79.104.60] helo=[192.168.0.20]) by yass.opencloud.co.nz with asmtp (TLS-1.0:DHE_RSA_AES_128_CBC_SHA:16) (Exim 4.34) id 1EFJlZ-0002RR-Pr; Wed, 14 Sep 2005 11:00:41 +1200 Message-ID: <43275A19.8030704@opencloud.com> Date: Wed, 14 Sep 2005 11:00:41 +1200 From: Oliver Jowett User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050324) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Kevin Grittner , pgsql-admin@postgresql.org, pgsql-jdbc@postgresql.org Subject: Re: [JDBC] ERROR: canceling query due to user request References: <27126.1126649920@sss.pgh.pa.us> In-Reply-To: <27126.1126649920@sss.pgh.pa.us> X-Enigmail-Version: 0.90.2.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 required=5 tests=[AWL=0.008] X-Spam-Level: X-Archive-Number: 200509/160 X-Sequence-Number: 18897 Tom Lane wrote: > This has been discussed before (try the pgsql-jdbc list archives). > I believe we concluded that an appropriate fix was to not consider the > cancel request "done" until the client sees the separate connection > dropped by the postmaster. libpq's cancel functions wait for that to > happen, and I thought that JDBC had been fixed as well --- maybe you are > using an old driver version? I thought this got done too, but looking at the current JDBC driver code I don't see it.. -O