I need to upgrade postgresql from 8.1.11 to 8.1.18. The documentation states to REINDEX all GiST indexes and REINDEX hash indexes on interval columns after the upgrade.
I googled the two items only to find the same comment with no instructions on what they are or how to do it. How can I check if I have any GiST indexes and hash indesxes on interval columns? Is there a command to reindex all databases at once or must I do each individually? Thanks Marc
