Thread: Row Level Locking !!

Is it possible that we can use row level locking in postgres.
If "yes",
then but is the proceedure and where i can found the documentation.

-MG

On Wednesday, 20. June 2001 07:46, Mahesh Guleria wrote:

> Is it possible that we can use row level locking in postgres.
> If "yes",
> then but is the proceedure and where i can found the documentation.

There is "something better than row level locking" called MVCC, or
Multi Version Concurrency Control for short.

See Chapter 9 of the User Guide:

http://www.postgresql.org/idocs/index.php?mvcc.html

Hope that helps,
Christof
--
          gl.aser . software engineering . internet service
       http://gl.aser.de/  . Planckstraße 7 . D-39104 Magdeburg

On Wed, Jun 20, 2001 at 01:03:49PM +0200, Christof Glaser wrote:
> On Wednesday, 20. June 2001 07:46, Mahesh Guleria wrote:
>
> > Is it possible that we can use row level locking in postgres.
> > If "yes",
> > then but is the proceedure and where i can found the documentation.

    I'd like to point out (for the new users around) that PostgreSQL
has had Multi Version Concurrency Control for quite some time. You don't
have to do anything special to use it. It's the default to handle
concurrency.

    -Roberto

--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer
* * * <- Tribbles  . . . <- Tribbles after a haircut