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

2013-08-29 Thread Kevin Grittner
Jaime Casanova wrote: > If that is the name of the database, then it probably is because > of the uppercase letters. Try this way: > > REINDEX DATABASE "PremierIEX" Some command shells will eat the quotes when done like that.  It may be necessary to use this style of quoting: REINDEX DATABASE '

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

2013-08-23 Thread Jaime Casanova
On Fri, Aug 23, 2013 at 3:39 PM, Yong Zhang wrote: > 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 > If that is the name of the database, then it probably is because o

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

2013-08-23 Thread Yong Zhang
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 pg

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

2013-08-23 Thread Thomas Kellerer
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 PostgreSQL version: 9.1.3 Operating system: Windows 7 64-bit Description: I always received error

[BUGS] BUG #8394: SQL command REINDEX doesn't work

2013-08-23 Thread yzhang
The following bug has been logged on the website: Bug reference: 8394 Logged by: Yz Primus Email address: 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 eit