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.



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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to