A minor issue, and patch. REINDEX DATABASE currently requires you to write REINDEX DATABASE dbname, which makes this a little less usable than we might like.
REINDEX on the catalog can cause deadlocks, which also makes REINDEX DATABASE not much use in practice, and is the reason there is no test for REINDEX DATABASE. Another reason why it is a little less usable than we might like. Seems we should do something about these historic issues in the name of product usability. Attached patch allows new syntax for REINDEX DATABASE, without needing to specify dbname. That version of the command skips catalog tables, as a way of avoiding the known deadlocks. Patch also adds a test. -- Simon Riggs http://www.EnterpriseDB.com/
reindex_not_require_database_name.v2.patch
Description: Binary data
