LOCK
Synopsis
Use the LOCK
statement to lock a table.
Syntax
lock_table ::= LOCK [ TABLE ] { { [ ONLY ] name [ * ] } [ , ... ] }
[ IN lockmode MODE ] [ NOWAIT ]
lockmode ::= ACCESS SHARE
| ROW SHARE
| ROW EXCLUSIVE
| SHARE UPDATE EXCLUSIVE
| SHARE
| SHARE ROW EXCLUSIVE
| EXCLUSIVE
| ACCESS EXCLUSIVE
lock_table
lockmode
Semantics
lock_table
name
Specify a table to lock.
lockmode
- Only
ACCESS SHARE
lock mode is supported at this time. - All other modes listed in lockmode are under development.
ACCESS SHARE
| ROW SHARE
| ROW EXCLUSIVE
| SHARE UPDATE EXCLUSIVE
| SHARE
| SHARE ROW EXCLUSIVE
| EXCLUSIVE
| ACCESS EXCLUSIVE