Re: php with postgres - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: php with postgres
Date
Msg-id 1058896656.46558.87.camel@jester
Whole thread Raw
In response to Re: php with postgres  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: php with postgres  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> > 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.

pgsql-hackers by date:

Previous
From: "Darren King"
Date:
Subject: Re: suggestions to improve postgresql suitability for data-mining
Next
From: Nailah Ogeer
Date:
Subject: Checkpoints