Which database object can be locked explicitly?
Which database object can be locked explicitly?
A table is a database object that can be explicitly locked. This is done using commands such as LOCK TABLE ... IN EXCLUSIVE MODE or LOCK TABLE ... IN SHARE MODE, which allow for specific control over how the table is accessed by different transactions. Rows, views, and indexes do not support explicit locking in the same way tables do.
A table is only object that can be explicitly locked with following command : LOCK TABLE ... IN EXCLUSIVE|SHARE MODE;