Re: Small question

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