Bruce Momjian <[EMAIL PROTECTED]> writes: > In private email with Tatsuo, I learned it is for the new loadable > encoding patch, and he wants to use the index from the syscache. The > reason for the partial index is because the index itself would not be > unique, but a partial index would be unique. > Because the index is part of the syscache, we have to create it as part > of initdb bootstrap, rather than in the initdb script.
This sounds like a really bad idea to me. A syscache based on a partial index is almost certainly not going to work. Before we invest in a lot of effort making bootstrap, syscache, and who knows what else support partial indexes, I want to see a very clear explanation why we must do it. Note I am looking for "*must* do it", not "it makes this other part of the system a little simpler". regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]