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
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? |