Re: BUG #8394: SQL command REINDEX doesn't work

yzhang(at)trinityusa(dot)com wrote on 23.08.2013 18:00:
> The following bug has been logged on the website:
>
> Bug reference: 8394
> Logged by: Yz Primus
> Email address: yzhang(at)trinityusa(dot)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
>
Quote from the manual:

Presently, REINDEX DATABASE and REINDEX SYSTEM can only reindex the current database,
so their parameter must match the current database's name.

So you need to specify the name of the current database even though it's not really needed.