Re: Transaction blocks

From: Alexander Kotelnikov <sacha(at)myxomop(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Transaction blocks
Date: 2005-08-10 15:13:23
Message-ID: 87zmrp965o.fsf@myxomop.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

>>>>> On Wed, 10 Aug 2005 17:37:28 +0400
>>>>> "AK" == Alexander Kotelnikov <sacha(at)myxomop(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-08-10 19:00:53 Re: using interval in a query with a column for the interval value?
Previous Message Alexander Kotelnikov 2005-08-10 13:37:28 Transaction blocks