Implicit Lock Row

From: "Antoine Lobato" <Antoine(dot)Lobato(at)wanadoo(dot)fr>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Implicit Lock Row
Date: 2002-10-05 22:05:03
Message-ID: 006601c26cbb$42206a60$deb8243e@Wantoine
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-10-05 23:03:41 Re: Proposed LogWriter Scheme, WAS: Potential Large Performance
Previous Message Antoine Lobato 2002-10-05 21:56:37 Implicit Lock Row