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

From: Neil Conway <neilc(at)samurai(dot)com>
To: MargaretGillon(at)chromalloy(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to know if a TRANSACTION isn't completed
Date: 2005-07-01 01:10:15
Message-ID: 42C497F7.8020803@samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

MargaretGillon(at)chromalloy(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albert Vernon Smith 2005-07-01 01:11:15 Re: optimizer not optimizing
Previous Message David Pratt 2005-07-01 00:25:45 Re: Advice on structure /sequence / trigger