Re: Small question

Tom Lane wrote:
> Jan Wieck <janwieck@yahoo.com> writes:
> > Joep deVocht wrote:
> >> Is there a way to determine whether a transaction
> >> is started and not ended yet?
>
> >     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.
>
> If you're in TRANSACTION ABORT state, I do not think that will work.
>
> Offhand this seems more of a protocol issue.  A straightforward solution
> would be to add a status indicator (with three states: out of
> transaction, in transaction, in aborted transaction) to the
> ReadyForQuery message, but we can't do that without a protocol change,
> which is probably more trouble than it's worth.

Yes, I was wondering if it was worth having the client call the function
at the end of every query.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026