The following bug has been logged on the website:
Bug reference: 8394
Logged by: Yz Primus
Email address: yzhang@trinityusa.com
PostgreSQL version: 9.1.3
Operating system: Windows 7 64-bit
Description:
I always received error when trying to run SQL command REINDEX either from
pgAdmin III or psql. If I ran REINDEX DATABASE it threw error:
ERROR: syntax error at end of input
LINE 1: REINDEX DATABASE
If I ran REINDEX DATABASE mydb it threw error:
ERROR: can only reindex the currently open database