Re: locks and "select for update"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wayne Cuddy <lists-pgsql(at)useunix(dot)net>
Cc: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: locks and "select for update"
Date: 2012-08-31 19:28:05
Message-ID: 17727.1346441285@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Wayne Cuddy <lists-pgsql(at)useunix(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Samuel Gendler 2012-09-01 01:53:23 prepared statement in crosstab query
Previous Message Wayne Cuddy 2012-08-31 17:05:54 locks and "select for update"