Thanks, comments updated.
---------------------------------------------------------------------------
Walter Cruz wrote:
> 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
-- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +