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