reindex creates predicate lock on index root

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: <pgsql-hackers@postgresql.org>
Date: 2011-06-08T00:45:43Z
Lists: pgsql-hackers
During testing of the SSI DDL changes I noticed that a REINDEX INDEX
created a predicate lock on page 0 of the index.  This is pretty
harmless, but mildly annoying.  There are a few other places where
it would be good to suppress predicate locks; these are listed on
the R&D section of the Wiki.  I hope to clean some of these up in
9.2. Unless a very clean and safe fix for the subject issue pops out
on further review, I'll add this to that list.
 
-Kevin