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

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_eater(at)gmx(dot)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

yzhang(at)trinityusa(dot)com <mailto: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 <mailto: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.