How to know if a TRANSACTION isn't completed

Поиск
Список
Период
Сортировка
От MargaretGillon@chromalloy.com
Тема How to know if a TRANSACTION isn't completed
Дата
Msg-id OF28F20D64.E176C453-ON88257030.007D1601-88257030.007D3E1C@CHROMALLOY.COM
обсуждение исходный текст
Ответы Re: How to know if a TRANSACTION isn't completed  (Neil Conway <neilc@samurai.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: COnsidering a move away from Postgres
Следующее
От: "Steve - DND"
Дата:
Сообщение: Transparent i18n?