Re: [HACKERS] How to ignore system indexes

> I'm trying to implement REINDEX command.
> Because the command is to repair system indexes,we
> coundn't rely on system indexes when we call the
> command.
> 
> I added locally an option of standalone postgres to ignore
> system indexes and am add/changing ignore_system_
> indexes stuff.
> 
> 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 better to limit changes required for REINDEX
> command ? 

One solution is to use pg_upgrade.  It allows an initdb and recreate of
all tables without reload.
--  Bruce Momjian                        |  http://www.op.net/~candle 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, Pennsylvania 19026