↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Search PostgreSQL documentation

PG 18 · Browse by category, or enter a name or keyword

Category index12
ACCESS EXCLUSIVELock ModesReferenceLock modes · Table lockTable lock Conflicts with locks of all modes (ACCESS SHARE, ROW SHARE, ROW EXCLUSIVE, SHARE UPDATE EXCLUSIVE, SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and ACCESS EXCLUSIVE). This mode guarante… ACCESS SHARELock ModesReferenceLock modes · Table lockTable lock Conflicts with the ACCESS EXCLUSIVE lock mode only. EXCLUSIVELock ModesReferenceLock modes · Table lockTable lock Conflicts with the ROW SHARE, ROW EXCLUSIVE, SHARE UPDATE EXCLUSIVE, SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and ACCESS EXCLUSIVE lock modes. This mode allows only concurrent ACCES… FOR KEY SHARELock ModesReferenceLock modes · Row lockRow lock Behaves similarly to FOR SHARE, except that the lock is weaker: SELECT FOR UPDATE is blocked, but not SELECT FOR NO KEY UPDATE. A key-shared lock blocks other transactions from perf… FOR NO KEY UPDATELock ModesReferenceLock modes · Row lockRow lock Behaves similarly to FOR UPDATE, except that the lock acquired is weaker: this lock will not block SELECT FOR KEY SHARE commands that attempt to acquire a lock on the same rows. Thi… FOR SHARELock ModesReferenceLock modes · Row lockRow lock Behaves similarly to FOR NO KEY UPDATE, except that it acquires a shared lock rather than exclusive lock on each retrieved row. A shared lock blocks other transactions from performi… FOR UPDATELock ModesReferenceLock modes · Row lockRow lock FOR UPDATE causes the rows retrieved by the SELECT statement to be locked as though for update. This prevents them from being locked, modified or deleted by other transactions until… ROW EXCLUSIVELock ModesReferenceLock modes · Table lockTable lock Conflicts with the SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and ACCESS EXCLUSIVE lock modes. ROW SHARELock ModesReferenceLock modes · Table lockTable lock Conflicts with the EXCLUSIVE and ACCESS EXCLUSIVE lock modes. SHARELock ModesReferenceLock modes · Table lockTable lock Conflicts with the ROW EXCLUSIVE, SHARE UPDATE EXCLUSIVE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and ACCESS EXCLUSIVE lock modes. This mode protects a table against concurrent data chang… SHARE ROW EXCLUSIVELock ModesReferenceLock modes · Table lockTable lock Conflicts with the ROW EXCLUSIVE, SHARE UPDATE EXCLUSIVE, SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and ACCESS EXCLUSIVE lock modes. This mode protects a table against concurrent dat… SHARE UPDATE EXCLUSIVELock ModesReferenceLock modes · Table lockTable lock Conflicts with the SHARE UPDATE EXCLUSIVE, SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and ACCESS EXCLUSIVE lock modes. This mode protects a table against concurrent schema changes and…

Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.

Searching every version by default. Manual pages are indexed for PostgreSQL 10–20; the reference library and extension catalogue are not version-bound.

all: every version pg17: one version ex: extensions only ↑↓ select ↵ open