Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f17Knxx01335 for ; Wed, 7 Feb 2001 15:50:00 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f17KnL910032; Wed, 7 Feb 2001 15:49:21 -0500 (EST) To: Bruce Momjian cc: "Thies C. Arntzen" , Rasmus@candle.pha.pa.us, Lerdorf , PostgreSQL-interfaces Subject: Re: PostgreSQL and PHP persistent connections In-reply-to: <200102071912.OAA27530@candle.pha.pa.us> References: <200102071912.OAA27530@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Wed, 07 Feb 2001 14:12:26 -0500" Date: Wed, 07 Feb 2001 15:49:21 -0500 Message-ID: <10029.981578961@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/48 X-Sequence-Number: 1001 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 ... regards, tom lane