Re: php with postgres

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, Marcus Börger <marcus(dot)boerger(at)post(dot)rwth-aachen(dot)de>, ivan <iv(at)psycho(dot)pl>, Joe Conway <mail(at)joeconway(dot)com>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: php with postgres
Date: 2003-07-22 18:51:35
Message-ID: 200307221851.h6MIpZ110672@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dennis Gearon 2003-07-22 18:55:22 Re: Checkpoints
Previous Message Josh Berkus 2003-07-22 18:46:39 Re: Criteria for contrib/ versus gborg?