On Fri, Aug 23, 2013 at 3:39 PM, Yong Zhang <yzh...@trinityusa.com> 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 of the uppercase letters. Try this way: REINDEX DATABASE "PremierIEX" -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs