Re: php with postgres - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: php with postgres
Date
Msg-id 200307221851.h6MIpZ110672@candle.pha.pa.us
Whole thread Raw
In response to Re: php with postgres  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers
Yes, but you probably want old clients to  be able to use the new nested
transaction code.

---------------------------------------------------------------------------

Rod Taylor wrote:
-- Start of PGP signed section.
> > > Won't that break when we have nested transactions implemented?  i.e. 
> > > begin;commit; would just open a sub transaction and have no effect on the 
> > > outer transaction...
> > 
> > Yes, it would break.  I am not sure how we are going to flag that we
> > want to rollback all nested transactions, maybe ROLLBACK ALL.
> 
> Shouldn't the results of PQtransactionStatus() override any 'pre-canned'
> guess about how to abort a potential transaction since you know the
> exact state of the protocol?
> 
> If PQprotocolVersion() == 2 then do things the old way (always begin /
> rollback).
> 
> If either of the above functions are not present (pre-7.4 version of
> PostgreSQL) then always begin / rollback.
-- End of PGP section, PGP failed!

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Criteria for contrib/ versus gborg?
Next
From: The Hermit Hacker
Date:
Subject: Re: Criteria for contrib/ versus gborg?