Ulrich Wisser <[EMAIL PROTECTED]> writes: > -bash-2.05b$ postgres -D /var/lib/pgsql/data/ -O -P CLIX1 > ... > backend> REINDEX DATABASE CLIX1 > ERROR: REINDEX DATABASE: Can be executed only on the currently open > database.
The database name is evidently all upper case, so you need double
quotes:
REINDEX DATABASE "CLIX1"
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
