Thread: How to know if a TRANSACTION isn't completed

I am trying to adapt a class to Postgresql that was written for SQLServer.
As an error check the class counts open transactions to make sure all
previous transactions have been completed.  In SQLServer there is a command
@@TRANCOUNT  which tells how many transactions are open on the server for
the current connection.

Is there  a similar command in Postgresql so that the client application
can find out if there's an unresolved transaction before it starts a new
one?

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

MargaretGillon@chromalloy.com wrote:
> Is there  a similar command in Postgresql so that the client application
> can find out if there's an unresolved transaction before it starts a new
> one?

See PQtransactionStatus() in libpq; if you're using a different language
interface, it should provide some means to get the same information.

http://developer.postgresql.org/docs/postgres/libpq-status.html

-Neil

> MargaretGillon@chromalloy.com wrote:
> > Is there  a similar command in Postgresql so that the client
application
> > can find out if there's an unresolved transaction before it starts a
new
> > one?
>
> See PQtransactionStatus() in libpq; if you're using a different language
> interface, it should provide some means to get the same information.
>
> http://developer.postgresql.org/docs/postgres/libpq-status.html
>
> -Neil

I am using Visual FoxPro with WINDOWS-ODBC to get to a Postgresql 7.3.4
database on a Redhat9 server. Is there an equilavent command I can use with
ODBC?

Margaret