> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>
> "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> > There are fairly many places using system indexes.
> > Probably I would be able to change them.
> > But is it preferable or possible to force other developers
> > to take ignore_system_indexes mode into account ?
>
> Is it really necessary to touch all those places?
>
> Seems to me that if a person needs to rebuild system indexes,
> he would be firing up a standalone backend and running
> REINDEX --- and darn little else. As long as none of the
> support code required by REINDEX insists on using an index,
> it doesn't matter what the rest of the system requires.
>
OK,I would limit changes only for REINDEX command.
> You might even think about doing the reindex in bootstrap mode,
> though I don't know if that would be easier or harder.
>
Yes,bootstrap mode is a natural selection. Jan has already tried
it and there was a problem of time quliafication. I don't know it is
a big obstacle or not. I prefer standalone postgres because
there's a possibility to call various SQL commands together
with REINDEX command.
Of cource,time qualification is no longer a problem in standalone
postgres.
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp