Received: from mail.retep.org.uk ([216.126.85.184]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f17M9Qx08768 for ; Wed, 7 Feb 2001 17:09:26 -0500 (EST) (envelope-from peter@retep.org.uk) Received: from heather.retep.org.uk ([193.113.118.141]) (authenticated) by mail.retep.org.uk (8.11.1/8.11.1) with ESMTP id f17M8vR08680; Wed, 7 Feb 2001 17:08:58 -0500 (EST) (envelope-from peter@retep.org.uk) Message-Id: <5.0.2.1.0.20010207220624.00a32670@mail.retep.org.uk> X-Sender: peter@mail.retep.org.uk X-Mailer: QUALCOMM Windows Eudora Version 5.0.2 Date: Wed, 07 Feb 2001 22:07:28 +0000 To: Bruce Momjian , Tom Lane From: Peter Mount Subject: Re: PostgreSQL and PHP persistent connections Cc: "Thies C. Arntzen" , rasmus@php.net, PostgreSQL-interfaces In-Reply-To: <200102072050.PAA12110@candle.pha.pa.us> References: <10029.981578961@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200102/54 X-Sequence-Number: 1007 At 15:50 07/02/01 -0500, Bruce Momjian wrote: > > Bruce Momjian writes: > > > We discussed using 'ROLLBACK' before passing a connection to a new user, > > > but the problem was that ROLLBACK with no open transaction causes a > > > server log error message. We discussed adding 'ROLLBACK SILENT' to fix > > > this, but I believe a better, more portable solution is a simple "BEGIN > > > WORK;ROLLBACK". This will do nothing if there is no open transaction, > > > > How is that an improvement? It only changes the case in which you get > > a NOTICE from not-in-transaction to in-transaction ... > >Well, the most common case is that you are not in a transaction. Also (JDBC again), it would ensure that no transaction was around when a connection was passed to a new client. By default it should be in autocommit mode. Peter >-- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026