From: | justin <justin(at)emproshunts(dot)com> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Fetch for Update |
Date: | 2008-07-28 16:32:07 |
Message-ID: | 488DF487.1090604@emproshunts.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bob Pawley wrote:
> I haven't been able to find much information on Fetch for Update. Does
> 8.3 support this command??
>
> If so, could someone please point out my error in the following?
>
> Bob
>
>
> BEGIN
> SELECT count (p_id.pid.process_id) INTO Proccount
> FROM p_id.p_id
> WHERE process_id = new.process_id;
>
> Declare
> procgraphic cursor for
> select process_id
> from p_id.p_id
> where p_id.p_id.p_id_id = proc_count.p_id_id;
>
> Begin
>
> Fetch first in procgraphic for update
> Update p_id.p_id
> set proc_graphic_position = one
> From graphics.proc_position
> where graphics.proc_position.proc_count = proccount;
>
>
Theres the Select for update
http://www.postgresql.org/docs/8.1/static/sql-select.html#SQL-FOR-UPDATE-SHARE
which locks the records for the transaction
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2008-07-28 16:33:34 | Re: should i need to install xml library in postgresql inorder to work on xml file? |
Previous Message | aravind chandu | 2008-07-28 16:25:47 | should i need to install xml library in postgresql inorder to work on xml file? |