Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> The following section
> titled "Locking and Tables", has two subsections, "Table-level locks" and
> "Row-level locks". Under table-level locks we find lock names such as
> RowShareLock and RowExclusiveLock -- are those table-level locks?
Yes, despite the names. (The various lock-type names are pretty
horrible IMHO, but they are claimed to be Oracle-compatible.)
Anything you do with a LOCK command is a table-level lock.
> Under row-level locks we find no specific lock names mentioned.
The only row-level locking mechanism available to users is
to UPDATE, DELETE, or SELECT FOR UPDATE a particular row.
All rows affected by such a command are locked against other
such commands (but not against plain SELECT).
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2001-09-04 15:33:30|
|Subject: Re: [HACKERS] getting the oid for a new tuple in a BEFORE|
|Previous:||From: Tom Lane||Date: 2001-09-04 14:51:22|
|Subject: Re: Build problem with CVS version |