How to know if a TRANSACTION isn't completed

From: MargaretGillon(at)chromalloy(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: How to know if a TRANSACTION isn't completed
Date: 2005-06-30 23:01:25
Message-ID: OF28F20D64.E176C453-ON88257030.007D1601-88257030.007D3E1C@CHROMALLOY.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve - DND 2005-06-30 23:16:01 Transparent i18n?
Previous Message Tom Lane 2005-06-30 22:32:59 Re: COnsidering a move away from Postgres