Thread: locking granularity

locking granularity

From
Chandralaksana Natalia
Date:

Does anyone know, or know where to find, information about whether postgresql allows you to lock a tuple, a table, a page?

When the source code refers to oid, is it tuple id, or it could mean a table id/ or some other objects' id?

Thanks a lot,

Natalia Chandralaksana



Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

Re: locking granularity

From
Bruno Wolff III
Date:
On Tue, Feb 04, 2003 at 17:26:09 -0800,
  Chandralaksana Natalia <npostgresql@yahoo.com> wrote:
>
> Does anyone know, or know where to find, information about whether postgresql allows you to lock a tuple, a table, a
page? 

http://developer.postgresql.org/docs/postgres/explicit-locking.html
has a good discussion of user accessible locks.