Skip site navigation (1) Skip section navigation (2)

Re: Re: PostgreSQL and PHP persistent connections

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Jan Wieck <janwieck(at)Yahoo(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Thies C(dot) Arntzen" <thies(at)digicol(dot)de>, rasmus(at)php(dot)net, PostgreSQL-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Re: PostgreSQL and PHP persistent connections
Date: 2001-02-08 14:18:25
Message-ID: 200102081418.JAA16051@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-jdbc
> > > 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.

It is the multi-command issue that prevented me from suggesting checking
the return status.  If they are leaving an open transaction after
disconnecting, they could be doing any crazy thing.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-interfaces by date

Next:From: Colin.HillDate: 2001-02-08 14:36:43
Subject: ODBC for ver 7 (Windows 2000)
Previous:From: Jan WieckDate: 2001-02-08 13:10:11
Subject: Re: PostgreSQL and PHP persistent connections

pgsql-jdbc by date

Next:From: Raymond ChuiDate: 2001-02-08 19:43:00
Subject: How to make PostgreSQL JDBC drive get PGTZ?
Previous:From: Jan WieckDate: 2001-02-08 13:10:11
Subject: Re: PostgreSQL and PHP persistent connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group