Thanks for the prompt response. But that's what I tried and it didn't work. I
tried following command in both pgAdmin III and psql:
REINDEX DATABASE PremierIEX
Then I got error
ERROR: can only reindex the currently open database
PremierIEX is my current database. In pgAdmin III it threw extra info:
SQL state: 0A000
Thanks,
Yong
-----Original Message-----
From: Thomas Kellerer [mailto:spam_ea...@gmx.net]
Sent: Friday, August 23, 2013 3:13 PM
To: Yong Zhang
Cc: Yong Zhang
Subject: Re: BUG #8394: SQL command REINDEX doesn't work
yzh...@trinityusa.com <mailto:yzh...@trinityusa.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: yzh...@trinityusa.com <mailto:yzh...@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
>
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.
