To match the description on http://momjian.us/main/writings/pgsql/sgml/explicit-locking.html
*** ../../include/storage/lock.h.orig 2006-10-05 00:25: 06.000000000 -0300
--- ../../include/storage/lock.h 2006-10-05 00:31:16.000000000 -0300
***************
*** 109,116 ****
#define AccessShareLock 1 /* SELECT */
#define RowShareLock 2 /* SELECT FOR UPDATE/FOR SHARE */
#define RowExclusiveLock 3 /* INSERT, UPDATE, DELETE */
! #define ShareUpdateExclusiveLock 4 /* VACUUM (non-FULL) */
! #define ShareLock 5 /* CREATE INDEX */
#define ShareRowExclusiveLock 6 /* like EXCLUSIVE MODE, but allows ROW
* SHARE */
#define ExclusiveLock 7 /* blocks ROW SHARE/SELECT...FOR
--- 109,117 ----
#define AccessShareLock 1 /* SELECT */
#define RowShareLock 2 /* SELECT FOR UPDATE/FOR SHARE */
#define RowExclusiveLock 3 /* INSERT, UPDATE, DELETE */
! #define ShareUpdateExclusiveLock 4 /* VACUUM (non-FULL),ANALYZE, CREATE
! * INDEX CONCURRENTLY */
! #define ShareLock 5 /* CREATE INDEX (WITHOUT CONCURRENTLY) */
#define ShareRowExclusiveLock 6 /* like EXCLUSIVE MODE, but allows ROW
* SHARE */
#define ExclusiveLock 7 /* blocks ROW SHARE/SELECT...FOR
[]'s
- Walter
