possible to lock a single row in table? - Mailing list pgsql-sql

From bboett@erm1.u-strasbg.fr (Bruno Boettcher)
Subject possible to lock a single row in table?
Date
Msg-id 20010620164636.J13678@erm1.u-strasbg.fr
Whole thread Raw
Responses Re: possible to lock a single row in table?
Re: possible to lock a single row in table?
List pgsql-sql
Hello!
i have a lots of threads that work on a table, making insertions,
updates removes.....

now i certain cases its important to keep data integrity, so i looked
into locks....


all i found was a lock function that locks the entire table....

now even in shared mode, if i understand it well this means that as long
as the locking procedure isn't finished, no other thread can update or
delete data, right? Thats really harsh, since there are really an awful
lot of threads....

isn't it possible to lock only a specific row?

and what happens to other insert queries whilst the lock is operational?
Are they postponed and the valling thread waits, or does the call return
with an error?

-- 
ciao bboett
==============================================================
bboett@earthling.net
http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett
===============================================================
the total amount of intelligence on earth is constant.
human population is growing....


pgsql-sql by date:

Previous
From: Markus Wagner
Date:
Subject: evaluating values of attributes from computed attribute names in trigger function
Next
From: "Josh Berkus"
Date:
Subject: Re: log file