Re: Row Level Locking !!

From: Christof Glaser <gcg(at)gl(dot)aser(dot)de>
To: "Mahesh Guleria" <mahesh(at)himline(dot)com>, <pgsql-sql(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Row Level Locking !!
Date: 2001-06-20 11:03:49
Message-ID: 01062013035000.00721@pinguin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pgsql-admin 2001-06-20 13:18:29 Re(2): 7.0.3 -> 7.1.2; pg_setlocale error
Previous Message Richard Huxton 2001-06-20 10:02:32 Re: [SQL] log file

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Wagner 2001-06-20 12:53:32 evaluating values of attributes from computed attribute names in trigger function
Previous Message Richard Huxton 2001-06-20 10:02:32 Re: [SQL] log file