Re: PLPGSQL: Using Transactions and locks

You cannot have nested transactions, thus you can't have BEGIN/COMMIT
inside your plpgsql function.

You can do locking, by doing this: EXECUTE ''LOCK foobar'';


On Wed, 13 Jun 2001, Allan Kamau wrote:

> Hi all,
> How do I write transaction statements like 'BEGIN
> WORK'... in PLPGSQL.
> Also how do I write lock statements in the same.
> Thank you in advance.
>
> Allan Kamau
>
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year!  http://personal.mail.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>