Advisory locking

A means for creating locks which have application-defined meanings

Advisory locking is a means for creating locks which have application-defined meanings.

Advisory locking was added as a core feature in PostgreSQL 8.2, replacing the previous userlock contrib module.

Functions

  14 13 12 11 10 9.6 9.5 9.4 9.3 9.2 9.1 9.0 8.4 8.3 8.2 8.1 8.0 7.4 7.3 7.2 7.1 7.0 6.5 6.4 6.3 6.2 6.1 6.0
pg_advisory_lock()                                                        
pg_advisory_lock_shared                                                        
pg_advisory_unlock()                                                        
pg_advisory_unlock_all()                                                        
pg_advisory_unlock_shared()                                                        
pg_advisory_xact_lock()                                                        
pg_advisory_xact_lock_shared()                                                        
pg_try_advisory_lock()                                                        
pg_try_advisory_lock_shared()                                                        
pg_try_advisory_xact_lock()                                                        
pg_try_advisory_xact_lock_shared()                                                        

Change history

Categories

Locking

See also

pg_try_advisory_lock(), pg_advisory_unlock(), pg_advisory_unlock_all()