Postgres Pro
Downloads
Home   >   mailing lists

Re: REINDEX problem - Mailing list pgsql-general

From Tom Lane
Subject Re: REINDEX problem
Date
Msg-id 22761.1092404849@sss.pgh.pa.us
Whole thread Raw
In response to REINDEX problem  (Ulrich Wisser <ulrich.wisser@relevanttraffic.se>)
List pgsql-general
Tree view 
Ulrich Wisser <ulrich.wisser@relevanttraffic.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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: ODBC Driver Standards
Next
From: Tom Lane
Date:
Subject: Re: heap errors - should I be worried?