From: Jan Wieck <janwieck@Yahoo.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Thies C. Arntzen <thies@digicol.de>
Cc: rasmus@php.net, PostgreSQL-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: PostgreSQL and PHP persistent connections
Date: Thu, 8 Feb 2001 08:10:11 -0500 (EST)
Message-ID: <200102081310.IAA03647@jupiter.greatbridge.com> (raw)
In-Reply-To: <200102072050.PAA12110@candle.pha.pa.us>
Bruce Momjian wrote:
> > Bruce Momjian <pgman@candle.pha.pa.us> 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.
Why not tracing PQcmdStatus(result) on the persistent
connection? It allways returns "BEGIN", "COMMIT" or
"ROLLBACK" for whatever you issued.
Well, it'll not catch the uncommon case that someone might
issue multiple queries in one statements (semicolon
separated). But that's IMHO bad practice anyway and the above
will avoid communication, context switching and eating up of
XID's until we have silent rollback in 7.2.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: janwieck@Yahoo.com, pgman@candle.pha.pa.us, tgl@sss.pgh.pa.us, thies@digicol.de
Subject: Re: PostgreSQL and PHP persistent connections
In-Reply-To: <200102081310.IAA03647@jupiter.greatbridge.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox