Re: Transaction blocks - Mailing list pgsql-novice

From Alexander Kotelnikov
Subject Re: Transaction blocks
Date
Msg-id 87zmrp965o.fsf@myxomop.com
Whole thread Raw
In response to Transaction blocks  (Alexander Kotelnikov <sacha@myxomop.com>)
Responses Re: Transaction blocks  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
>>>>> On Wed, 10 Aug 2005 17:37:28 +0400
>>>>> "AK" == Alexander Kotelnikov <sacha@myxomop.com> wrote:
AK>
AK> I believe, any procedure language function is a transaction block, and
AK> I think, I even read this somewere in docs, but can not find where
AK> now, so, is it true, for all languages (SQL, PL/pgsql, perl etc)?
AK>
AK> If yes, is it an ordinal transaction, just like one started with
AK> BEGIN?

And I forgot to ask:
there is no nested transactions in postgres, but is it possible to
start a transaction in a procedure?
--
Alexander Kotelnikov
Saint-Petersburg, Russia

pgsql-novice by date:

Previous
From: Alexander Kotelnikov
Date:
Subject: Transaction blocks
Next
From: Bruno Wolff III
Date:
Subject: Re: using interval in a query with a column for the interval value?