PostgreSQL Lock Conflicts

AccessShareLock

The AccessShareLock lock is a Table lock. This list shows the commands that acquire AccessShareLock and what locks conflicts with it.

The following commands acquire AccessShareLock Table lock

1. SELECT
2. COPY TO
3. ALTER TABLE ADD FOREIGN KEY (PARENT)

The following are table locks conflicting with AccessShareLock

1. AccessExclusiveLock