Skip to content
Snippets Groups Projects
  • Tom Lane's avatar
    a56a016c
    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
    History
    Repair some REINDEX problems per recent discussions. The relcache is
    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.
errcodes.h 17.72 KiB