Re: PL/pgSQL equivalent to PQtransactionStatus?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: PL/pgSQL equivalent to PQtransactionStatus?
Дата
Msg-id 48920DFE.1010909@archonet.com
обсуждение исходный текст
Ответ на Re: PL/pgSQL equivalent to PQtransactionStatus?  (Christophe <xof@thebuild.com>)
Список pgsql-general
Christophe wrote:
>
> On Jul 31, 2008, at 11:12 AM, Richard Huxton wrote:
>> A pl/pgsql function *always* executes within a transaction.
>
> Indeed so.  What I'm looking for is a way of detecting if a transaction
> block has been opened (i.e., we're within a BEGIN).

There is no difference between a transaction explicitly started with
BEGIN...COMMIT and one wrapping a single statement.

What were you planning to do differently if a BEGIN was issued?

--
   Richard Huxton
   Archonet Ltd

В списке pgsql-general по дате отправления:

Предыдущее
От: Christophe
Дата:
Сообщение: Re: PL/pgSQL equivalent to PQtransactionStatus?
Следующее
От: "Mike Gould"
Дата:
Сообщение: Using PostGres general distribution