Re: BUG #8394: SQL command REINDEX doesn't work - Mailing list pgsql-bugs

From Jaime Casanova
Subject Re: BUG #8394: SQL command REINDEX doesn't work
Date
Msg-id CAJKUy5hKeaOHnM=XhRmMQLpLSpg8qYPBm+_rfaukgu2241trVw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #8394: SQL command REINDEX doesn't work  ("Yong Zhang" <yzhang@trinityusa.com>)
Responses Re: BUG #8394: SQL command REINDEX doesn't work
List pgsql-bugs
On Fri, Aug 23, 2013 at 3:39 PM, Yong Zhang <yzhang@trinityusa.com> wrote:
> Thanks for the prompt response. But that's what I tried and it didn't wor=
k.
> 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 of
the uppercase letters. Try this way:

REINDEX DATABASE "PremierIEX"

--=20
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n
Phone: +593 4 5107566         Cell: +593 987171157

pgsql-bugs by date:

Previous
From: "Yong Zhang"
Date:
Subject: Re: BUG #8394: SQL command REINDEX doesn't work
Next
From: harukat@sraoss.co.jp
Date:
Subject: BUG #8397: pg_basebackup -x from new standby server sometimes causes Segmentation fault