Re: [GENERAL] REINDEX problem

2004-08-13 Thread Tom Lane
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

[GENERAL] REINDEX problem

2004-08-13 Thread Ulrich Wisser
Hello, the maintainance chapter in the docs gave me the impression that a reindex of some tables would be a good idea. Last night I took the database down, started up in single user mode and tried to reindex. The reindex of tables did work fine, but a reindex of the database did not. Please see