Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id F2BF9476DEB for ; Thu, 2 Jan 2003 23:22:43 -0500 (EST) Received: from leo.pcisys.net (leo.pcisys.net [207.76.102.240]) by postgresql.org (Postfix) with ESMTP id 9E067476F5B for ; Thu, 2 Jan 2003 23:20:06 -0500 (EST) Received: from [192.168.2.16] (moe.rbe45-80.cos.pcisys.net [216.229.45.80]) by leo.pcisys.net (8.12.5/8.12.5) via ESMTP id h034KNxD028777 for ; Thu, 2 Jan 2003 21:20:23 -0700 (MST) env-from (hierophant@pcisys.net) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.6 Date: Thu, 02 Jan 2003 21:20:12 -0700 Subject: Re: pg_pconnect+PostgreSQL cursors From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: <20021226165914.GA8628@city.gov.te.ua> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/6 X-Sequence-Number: 1751 on 12/26/02 9:59 AM, serg@city.gov.te.ua purportedly said: > I've got closing of cursor and transaction! why??? I use permanent connection, > why I've got closing of cursor and transaction!??? The "p" in "pconnect" means *persistent*, not permanent. The connection will persist after the script has completed, however, the connection is handled by the web server process and its true lifetime is only the lifetime of the process. For Apache, this will vary by configuration, and is difficult to predict when hosting multiple sites. Tip: persistent connections are only useful when you want (and have the resources to support) to minimize connection overhead. Any other use and you are likely to be severely disappointed. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"