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 2A02F9DCB6B for ; Thu, 15 Dec 2005 09:38:30 -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 03722-08 for ; Thu, 15 Dec 2005 09:38:33 -0400 (AST) X-Greylist: delayed 01:18:10.03277 by SQLgrey- Received: from galagonx.fixdial.interware.hu (galagonx.fixdial.interware.hu [195.70.45.31]) by postgresql.org (Postfix) with ESMTP id 8EE749DCB4A for ; Thu, 15 Dec 2005 09:38:27 -0400 (AST) Received: from szballa-xp.intra ([172.20.80.67]) by galagonx.fixdial.interware.hu with esmtp (Exim 3.36 #1 (Debian)) id 1EmtJU-0005Qf-00; Thu, 15 Dec 2005 14:38:28 +0100 Message-ID: <43A1715C.7000106@confinsystems.com> Date: Thu, 15 Dec 2005 14:36:28 +0100 From: Szabolcs BALLA User-Agent: Mozilla Thunderbird 1.0.5 (Windows/20050711) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jaime Casanova CC: pgsql-admin@postgresql.org Subject: Re: single click, double query References: <43A15F0B.6080306@confinsystems.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; 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/150 X-Sequence-Number: 19870 Yes, but they are our clients, and I can't say for them: please upgrade your client because if you use our applications the db server will have a performance problem...:( Jaime Casanova wrote: >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 ;) > >---------------------------(end of broadcast)--------------------------- >TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > >