Re: REINDEX problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: REINDEX problem
Date: 2004-08-13 13:47:29
Message-ID: 22761.1092404849@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-13 13:53:09 Re: heap errors - should I be worried?
Previous Message Andreas Pflug 2004-08-13 10:46:57 Re: [GENERAL] error moving table to tablespace