[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] How to know if a TRANSACTION isn't completed
From:       MargaretGillon () chromalloy ! com
Date:       2005-06-30 23:01:25
Message-ID: OF28F20D64.E176C453-ON88257030.007D1601-88257030.007D3E1C () CHROMALLOY ! COM
[Download RAW message or body]


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


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
[prev in list] [next in list] [prev in thread] [next in thread]