Make REINDEX DATABASE do what one would expect, namely reindex all indexes
Tom Lane <tgl@sss.pgh.pa.us>
Make REINDEX DATABASE do what one would expect, namely reindex all indexes in the database. The old behavior (reindex system catalogs only) is now available as REINDEX SYSTEM. I did not add the complementary REINDEX USER case since there did not seem to be consensus for this, but it would be trivial to add later. Per recent discussions.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/maintenance.sgml | modified | +2 −3 |
| doc/src/sgml/ref/reindex.sgml | modified | +45 −18 |
| src/backend/commands/indexcmds.c | modified | +24 −16 |
| src/backend/nodes/copyfuncs.c | modified | +3 −3 |
| src/backend/nodes/equalfuncs.c | modified | +3 −3 |
| src/backend/parser/gram.y | modified | +17 −5 |
| src/backend/parser/keywords.c | modified | +2 −1 |
| src/backend/tcop/utility.c | modified | +5 −4 |
| src/bin/psql/common.c | modified | +6 −4 |
| src/bin/psql/tab-complete.c | modified | +5 −4 |
| src/include/commands/defrem.h | modified | +5 −4 |
| src/include/nodes/parsenodes.h | modified | +3 −3 |