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 1598A9DCB73 for ; Thu, 15 Dec 2005 08:20:23 -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 88512-03 for ; Thu, 15 Dec 2005 08:20:25 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id AD66C9DCB8A for ; Thu, 15 Dec 2005 08:20:20 -0400 (AST) Received: from galagonx.fixdial.interware.hu (galagonx.fixdial.interware.hu [195.70.45.31]) by svr4.postgresql.org (Postfix) with ESMTP id 96E045AF1F1 for ; Thu, 15 Dec 2005 12:20:23 +0000 (GMT) Received: from szballa-xp.intra ([172.20.80.67]) by galagonx.fixdial.interware.hu with esmtp (Exim 3.36 #1 (Debian)) id 1Ems5r-0004pn-00 for ; Thu, 15 Dec 2005 13:20:19 +0100 Message-ID: <43A15F0B.6080306@confinsystems.com> Date: Thu, 15 Dec 2005 13:18:19 +0100 From: Szabolcs BALLA User-Agent: Mozilla Thunderbird 1.0.5 (Windows/20050711) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: single click, double query Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/147 X-Sequence-Number: 19867 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? note: I can't forbid a "too fast" connections by IP because they come throught firewall. Thanks, Szabek