Re: partial index on system indexes? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: partial index on system indexes?
Date
Msg-id 200207240207.g6O27ZE17743@candle.pha.pa.us
Whole thread Raw
In response to partial index on system indexes?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: partial index on system indexes?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tatsuo Ishii wrote:
> It seems bootstrap parser(bootparse.y) does not accept partial index
> definitions. Is there any reason for this?

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.

Tatsuo mentioned there is a boolean, and he only wants cases where the
boolean is true, and such values are unique.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: partial index on system indexes?
Next
From: Marc Lavergne
Date:
Subject: Re: C vs. C++ contributions