Postgres Pro
Downloads
Home   >   mailing lists

Re: locks and "select for update" - Mailing list pgsql-sql

From Tom Lane
Subject Re: locks and "select for update"
Date
Msg-id 17727.1346441285@sss.pgh.pa.us
Whole thread Raw
In response to locks and "select for update"  (Wayne Cuddy <lists-pgsql@useunix.net>)
List pgsql-sql
Tree view 
Wayne Cuddy <lists-pgsql@useunix.net> writes:
> The documentation about concurrency states that all the different types
> of locks are table locks even if the word row appears in the lock name.

Section 13.3.1, "Table-level Locks", states that all the lock types
discussed therein are table-level locks, even though some of them have
names containing the word ROW for historical reasons.  I don't see how
you'd read it to imply that there are no finer-grained locks anywhere in
Postgres.
        regards, tom lane

pgsql-sql by date:

Previous
From: Wayne Cuddy
Date:
Subject: locks and "select for update"
Next
From: Samuel Gendler
Date:
Subject: prepared statement in crosstab query