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