X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3E23F9DC819 for ; Thu, 15 Dec 2005 09:23:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00865-04 for ; Thu, 15 Dec 2005 09:23:38 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194]) by postgresql.org (Postfix) with ESMTP id 7063A9DC807 for ; Thu, 15 Dec 2005 09:23:32 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 57so344424wri for ; Thu, 15 Dec 2005 05:23:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=r0z+749jceWynVPa9I4LOID4JDHkGwBbcl07u+GAtSHTnuQ3AQ5wFlCbjwJ1hv/z3qxfkKXeIaE/YakKyooDUOTKh/zz5M5F6zHMc+KRIpkjIVSdswrUIA/9gC4uvlmEYNdw7PaROi46JOm5+WLzpqFLvXX56X1K+Qp2nQC6gWc= Received: by 10.54.80.7 with SMTP id d7mr2276512wrb; Thu, 15 Dec 2005 05:23:34 -0800 (PST) Received: by 10.54.98.6 with HTTP; Thu, 15 Dec 2005 05:23:34 -0800 (PST) Message-ID: Date: Thu, 15 Dec 2005 08:23:34 -0500 From: Jaime Casanova To: Szabolcs BALLA Subject: Re: single click, double query Cc: pgsql-admin@postgresql.org In-Reply-To: <43A15F0B.6080306@confinsystems.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <43A15F0B.6080306@confinsystems.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.104 required=5 tests=[AWL=0.104] X-Spam-Score: 0.104 X-Spam-Level: X-Archive-Number: 200512/148 X-Sequence-Number: 19868 On 12/15/05, Szabolcs BALLA wrote: > Hi, > > I have a strange problem with psql 7.4.7. > I have customers who run xp, with sp1 (with sp2 no problem), when they > report from our web-based application they send a query > after a single click. The same queries have been posted twice within a > few milliseconds. > How can I forbid this on db server side? Is it possible? if you see the problem just in clients with xp sp1 and not with xp sp2 then the problem is in the client not in the server... upgrade your xp clients to sp2... > note: I can't forbid a "too fast" connections by IP because they come > throught firewall. > > Thanks, > Szabek > > -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)