Re: partial index on system indexes?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: partial index on system indexes?
Date: 2002-07-24 02:07:35
Message-ID: 200207240207.g6O27ZE17743@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc Lavergne 2002-07-24 05:00:38 Re: C vs. C++ contributions
Previous Message Bruce Momjian 2002-07-24 01:57:09 Re: partial index on system indexes?