Advisory locking

A means for creating locks which have application-defined meanings

Advisory locking is a facility 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

  16 15 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()