Bruce Momjian wrote:
> Tom Lane wrote:
> > Jan Wieck <janwieck@yahoo.com> writes:
> > >> It seems like it might be possible for libpq (or other clients) to keep
> > >> track of the transaction state by paying attention to BEGIN, COMMIT,
> > >> ABORT command-completion tags and ERROR messages, but I haven't worked
> > >> through the details.
> >
> > > PQexec(c, "BEGIN; SELECT now()");
> >
> > > Will there even be a BEGIN command tag sent?
> >
> > Yes. PQexec doesn't tell you about it, but one comes through. (This
> > is certainly true in current sources, and I believe has always been true.)
> >
> > It'd be nastier if we allowed functions to change the transaction-block
> > state, but we don't...
>
> We only need one bit to pass the transaction status back to the client.
> Shame we can't throw that bit in there somewhere.
Huh? You can represent 3 possible states in one bit? I know
that I'm not too bad of a programmer, but you're far better
than me :-p
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com