Re: [GENERAL] How to know if a TRANSACTION isn't completed

2005-07-01 Thread MargaretGillon
> [EMAIL PROTECTED] 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 s

Re: [GENERAL] How to know if a TRANSACTION isn't completed

2005-06-30 Thread Neil Conway
[EMAIL PROTECTED] 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 ge

[GENERAL] How to know if a TRANSACTION isn't completed

2005-06-30 Thread MargaretGillon
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