sign in | join about | help | sitemap
Connecting Tech Pros Worldwide
Josué Maldonado's Avatar

Manual record locking


Question posted by: Josué Maldonado (Guest) on November 12th, 2005 01:03 AM
Hello list,

Is there a way to manual/explicit lock a record from within a plpgsql
function?

Thanks in advance

Josué Maldonado



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

1 Answer Posted
Nigel J. Andrews's Avatar
Nigel J. Andrews November 12th, 2005 01:03 AM
Guest - n/a Posts
#2: Re: Manual record locking

On Mon, 8 Dec 2003, Josué Maldonado wrote:
[color=blue]
> Hello list,
>
> Is there a way to manual/explicit lock a record from within a plpgsql
> function?[/color]


SELECT ... FOR UPDATE


--
Nigel Andrews



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

 
Not the answer you were looking for? Post your question . . .
196,848 members ready to help you find a solution.
Join Bytes.com

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 196,848 network members.
Post your question now . . .
It's fast and it's free

Popular Articles

Top Community Contributors