• Tom Lane's avatar
    Repair some REINDEX problems per recent discussions. The relcache is · a56a016c
    Tom Lane authored
    now able to cope with assigning new relfilenode values to nailed-in-cache
    indexes, so they can be reindexed using the fully crash-safe method.  This
    leaves only shared system indexes as special cases.  Remove the 'index
    deactivation' code, since it provides no useful protection in the shared-
    index case.  Require reindexing of shared indexes to be done in standalone
    mode, but remove other restrictions on REINDEX.  -P (IgnoreSystemIndexes)
    now prevents using indexes for lookups, but does not disable index updates.
    It is therefore safe to allow from PGOPTIONS.  Upshot: reindexing system catalogs
    can be done without a standalone backend for all cases except
    shared catalogs.
    a56a016c
postgres-ref.sgml 15 KB