X-Original-To: pgsql-php@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 21F1192322A for ; Fri, 23 May 2003 12:25:41 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 93055-04 for ; Fri, 23 May 2003 12:25:29 -0400 (EDT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by developer.postgresql.org (Postfix) with ESMTP id 4A7C4923527 for ; Fri, 23 May 2003 12:12:06 -0400 (EDT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.9/8.12.9) with ESMTP id h4NGAW62006422; Fri, 23 May 2003 10:10:32 -0600 (MDT) Date: Fri, 23 May 2003 09:58:32 -0600 (MDT) From: "scott.marlowe" To: Christopher Kings-Lynne Cc: Raphael Bauduin , David Busby , Subject: Re: Number of connections In-Reply-To: <15ff01c320d0$e89bb1f0$6500a8c0@fhp.internal> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-MailScanner: Found to be clean X-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/31 X-Sequence-Number: 2036 On Fri, 23 May 2003, Christopher Kings-Lynne wrote: > > Maybe a stupid question, but I wondered if when using persisten > > connection, I could be sure there would be no problem. From the doc, > > currval "Returns the value most recently obtained by nextval for this > > sequence in the current server process." > > > > Can you confirm me several script using the same persistent connection > > in parallel are in separate server processes? > > PHP will execute 'begin; rollback;' to your connection before passing it to > another PHP process, guaranteeing that unclosed transactions won't leak. Didn't it used to not do that? I remember posts about people having issues with transaction bleedover back in the day.