I currently develop an interface to simulate a indexed sequential file management with PostgreSql. I must reproduce the same philosophy used of control of locking of the records.

I seek a solution to lock and unlock implicitly a row of a table. The locking of several rows, of the same table or various tables, can last a long time and consequently locking cannot be included in a transaction for not to lock the whole table for the other users.

There is a viable solution with PostgreSql?

There is an accessible basic structure of locking?

Thank you.










I currently develop an interface to simulate a indexed 
sequential file management with PostgreSql. I must reproduce the same philosophy 
used of control of locking of the records.
I seek a solution to lock and unlock implicitly a row of a 
table. The locking of several rows, of the same table or various tables, can 
last a long time and consequently locking cannot be included in a transaction 
for not to lock the whole table for the other users.
There is a viable solution with PostgreSql?
There is an accessible basic structure of locking?
Thank you.
Sat, 5 Oct 2002 23:56:37 +0200
"Antoine Lobato" <Antoine.Lobato@wanadoo.fr>
Implicit Lock Row
On 5 Oct 2002 at 23:56, Antoine Lobato wrote:

> 
> I currently develop an interface to simulate a indexed sequential file 
> management with PostgreSql. I must reproduce the same philosophy used of 
> control of locking of the records.
> I seek a solution to lock and unlock implicitly a row of a table. The locking 
> of several rows, of the same table or various tables, can last a long time and 
> consequently locking cannot be included in a transaction for not to lock the 
> whole table for the other users.
> There is a viable solution with PostgreSql?
> There is an accessible basic structure of locking?

You can use select for update to lock rows.

HTH

Bye
 Shridhar

--
Strategy:	A long-range plan whose merit cannot be evaluated until sometime	
after those creating it have left the organization.


Mon, 07 Oct 2002 19:16:00 +0530
"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Re: Implicit Lock Row