How to know if a TRANSACTION isn't completed - Mailing list pgsql-general

From MargaretGillon@chromalloy.com
Subject How to know if a TRANSACTION isn't completed
Date
Msg-id OF28F20D64.E176C453-ON88257030.007D1601-88257030.007D3E1C@CHROMALLOY.COM
Whole thread Raw
Responses Re: How to know if a TRANSACTION isn't completed  (Neil Conway <neilc@samurai.com>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: COnsidering a move away from Postgres
Next
From: "Steve - DND"
Date:
Subject: Transparent i18n?