reindex creates predicate lock on index root

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: reindex creates predicate lock on index root
Date: 2011-06-08 00:45:43
Message-ID: 4DEE7FE7020000250003E2C1@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-06-08 00:48:50 Re: Domains versus polymorphic functions, redux
Previous Message Mike Pultz 2011-06-08 00:35:12 Re: smallserial / serial2