From: | Alex Pilosov <alex(at)pilosoft(dot)com> |
---|---|
To: | Allan Kamau <hugebirdwings(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PLPGSQL: Using Transactions and locks |
Date: | 2001-06-13 14:42:40 |
Message-ID: | Pine.BSO.4.10.10106131041570.17529-100000@spider.pilosoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org)
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | C. R. Oldham | 2001-06-13 14:43:03 | pg_dump problem |
Previous Message | Keith G. Murphy | 2001-06-13 14:39:47 | Re: Text data type doesn't accept newlines? |