X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CBDE1D1B4E8 for ; Fri, 7 Nov 2003 02:28:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 07372-02 for ; Thu, 6 Nov 2003 22:28:07 -0400 (AST) Received: from houston.familyhealth.com.au (fhnet.arach.net.au [203.22.197.21]) by svr1.postgresql.org (Postfix) with ESMTP id 028A3D1B93D for ; Thu, 6 Nov 2003 22:28:03 -0400 (AST) Received: from familyhealth.com.au (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9p1/8.12.9) with ESMTP id hA72RWoD043869; Fri, 7 Nov 2003 10:27:33 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <3FAB0406.5020409@familyhealth.com.au> Date: Fri, 07 Nov 2003 10:31:34 +0800 From: Christopher Kings-Lynne User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Bruce Momjian Cc: "scott.marlowe" , Stephen , pgsql-php@postgresql.org Subject: Re: Support for prepared queries References: <200311062253.hA6Mrsm03968@candle.pha.pa.us> In-Reply-To: <200311062253.hA6Mrsm03968@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/19 X-Sequence-Number: 2412 >>You'd have to write some kind of pooling solution to get that kind of >>behaviour. I don't know of anyone working on pooling in PHP. > > > Thought PHP5 does RESET ALL, that doesn't affect prepared queries, only > SET variables. I vote for a new command: RESET SESSION; Basically, we make that connection reset everythign - SET variables, open cursors, etc. I don't think we want to clobber prepared queries...i dunno. And we can add stuff to it without needing pool managers to change how they do things. Chris