Repair some REINDEX problems per recent discussions. The relcache is

Tom Lane <tgl@sss.pgh.pa.us>

Commit: a56a016ceb612cdee1ddc5990682f36d541e5b07
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2003-09-24T18:54:02Z
Releases: 7.4.1
Repair some REINDEX problems per recent discussions.  The relcache is
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.

Files