Re: [SQL] select ... for update in plpgsql - Mailing list pgsql-admin

From Cedar Cox
Subject Re: [SQL] select ... for update in plpgsql
Date
Msg-id Pine.LNX.4.21.0104241353420.21572-100000@nanu.visionforisrael.com
Whole thread Raw
In response to select ... for update in plpgsql  (Jie Liang <jliang@ipinc.com>)
List pgsql-admin
'select ... for update' needs to be inside a transaction.  plpgsql cannot
start or end transactions.  'begin' and 'end' are not transaction
statements.  (read the docs).

-Cedar

On Fri, 20 Apr 2001, Jie Liang wrote:

>
> Hi,
>
> I have a question about 'select ... for update';
> according to the docs,
> clause 'for update' will lock selected rows,
> I believe it should be put into a
> begin;
> select ... for update;
> update ...;
> end;
> block.
>
> however, if I use it in a plpgsql function,
> do I need another pair of begin...end?
> or say begin...end in plpgsql can lock chosen rows until
> updated ALL ROWS?
> if not, do you have any suggestion?
>
>
>
> Jie LIANG
>
> St. Bernard Software
>
> 10350 Science Center Drive
> Suite 100, San Diego, CA 92121
> Office:(858)320-4873
>
> jliang@ipinc.com
> www.stbernard.com
> www.ipinc.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)
>


pgsql-admin by date:

Previous
From: "Dan Browning"
Date:
Subject: Re: Large database help
Next
From: "Thomas Heller"
Date:
Subject: 7.1 performance