From: | Sébastien HEITZMANN <2le(at)2le(dot)net> |
---|---|
To: | "Allan Kamau" <hugebirdwings(at)yahoo(dot)com>, "Anatoly K(dot) Lasareff" <tolik(at)aaanet(dot)ru> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Transactions and Locks writing in PLPGSQL |
Date: | 2001-06-14 07:52:58 |
Message-ID: | 007501c0f4a7$11990290$473e05c0@CALISTO |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
And what happen when the function call an other function. Does this action
also be rolled back if the first fail ?
SEB
----- Original Message -----
From: "Anatoly K. Lasareff" <tolik(at)aaanet(dot)ru>
To: "Allan Kamau" <hugebirdwings(at)yahoo(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Thursday, June 14, 2001 7:49 AM
Subject: Re: [ADMIN] Transactions and Locks writing in PLPGSQL
> >>>>> "AK" == Allan Kamau <hugebirdwings(at)yahoo(dot)com> writes:
>
> AK> Hi all,
> AK> How do I write transaction statements like 'BEGIN
> AK> WORK'... in PLPGSQL.
> AK> Also how do I write lock statements in the same.
> AK> Thank you in advance.
>
> AK> Allan Kamau
>
> There is no possibility for this. See (from manual):
>
> (3) You also cannot have transactions in PL/pgSQL procedures. The
> entire function (and other functions called from
> therein) is executed in a transaction and PostgreSQL rolls back
> the results if something goes wrong. Therefore
> only one BEGIN statement is allowed.
>
> --
> Anatoly K. Lasareff Email: tolik(at)aaanet(dot)ru
> http://tolikus.hq.aaanet.ru:8080
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | brian | 2001-06-14 14:38:26 | vacuum error |
Previous Message | Anatoly K. Lasareff | 2001-06-14 05:49:46 | Re: Transactions and Locks writing in PLPGSQL |