Re: Small question

Joep deVocht wrote:
>
> Hi,
>
> Is there a way to determine whether a transaction
> is started and not ended yet? I.e. is it possible to
> check whether a "begin"was issued but the corresponding
> "commit/end" wasn't yet?
>
> I'm using the c++ interface for Postgres7.1.
> (But I hope the answer is independent of that)
>
> Many thanx in advance,

This question came from time to time, and many interfaces
seem to try to keep track of the actual transaction status in
order to emulate autocommit off behaviour and such.

The only one who's really able to tell the current
transaction state is the backend.

I think it's time to add a little boolean function, that
actually returns IsTransactionBlock(), and have a libpq side
wrapper around PQfn() calling it.

Any other opinions?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com