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

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Jaime Casanova <jaime(at)2ndquadrant(dot)com>, Yong Zhang <yzhang(at)trinityusa(dot)com>
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>, Thomas Kellerer <spam_eater(at)gmx(dot)net>
Subject: Re: BUG #8394: SQL command REINDEX doesn't work
Date: 2013-08-29 14:57:33
Message-ID: 1377788253.40583.YahooMailNeo@web162905.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jaime Casanova <jaime(at)2ndquadrant(dot)com> 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 '"PremierIEX"'

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message george.stragand 2013-08-29 21:08:56 BUG #8407: json_populate_record case sensitivity
Previous Message Magnus Hagander 2013-08-29 14:51:31 Re: BUG #8406: Postgresql 9.3 from OpenSCG dose not start automaticly when enalbled in system runlevel