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. ---------------------------(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
