X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A461BD9F3E for ; Mon, 3 Oct 2005 22:17:20 -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 07428-04 for ; Tue, 4 Oct 2005 01:17:14 +0000 (GMT) Received: from a2s4.a2hosting.com (a2s4.a2hosting.com [64.9.205.220]) by svr1.postgresql.org (Postfix) with ESMTP id C190BD9F38 for ; Mon, 3 Oct 2005 22:17:13 -0300 (ADT) Received: from user-1120q9s.dsl.mindspring.com ([66.32.105.60] helo=[192.168.1.10]) by a2s4.a2hosting.com with esmtpsa (TLSv1:RC4-SHA:128) (Exim 4.52) id 1EMbQj-0004Yu-3o; Mon, 03 Oct 2005 21:17:17 -0400 In-Reply-To: <226b0df80510030659m39c4f7fdn@mail.gmail.com> References: <226b0df80510030659m39c4f7fdn@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v733) Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed Message-Id: Cc: pgsql-php@postgresql.org Content-Transfer-Encoding: quoted-printable From: John DeSoi Subject: Re: Trouble with conections between php and postgre Date: Mon, 3 Oct 2005 21:17:15 -0400 To: luis linietsky X-Mailer: Apple Mail (2.733) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s4.a2hosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200510/2 X-Sequence-Number: 3270 On Oct 3, 2005, at 9:59 AM, luis linietsky wrote: > Hi !, first of all: sorry about my english, i'm not from us. > I 'm using latest versions of postgre 7.4 with php4 and apache2, on a > debian system. I'm working with a really big database, so there are > many querys that takes too much time to be executed (And there's > nothig to do about it). These querys blocks the php page while's being > loaded. The problem is that usually, one excepcts to stop those querys > or even close the conection if the user stops the explorer or closes > the window. However, this isn't hapening, the query keeps running in > the database, using resources. > I already try uselessly ignore_user_abort(False), and I don't want to > set a time limit. > =BFAny ideas? =BFAm I missing something ? There is a specific protocol for canceling a query in progress. Maybe =20= this PHP function will work for you: http://www.php.net/manual/en/function.pg-cancel-query.php John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL