RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...

> -----Original Message-----
> From: pgsql-hackers-owner(at)hub(dot)org
> The Hermit Hacker
>
> Can someone add something to the docs that gives an example of what should
> be used from the command line to reindex a database's system tables?
>
> All the man page says is use th e-O an d-P options :(
>
> I'm getting:
>
> psql -h pgsql horde
> ERROR: cannot read block 6 of pg_attribute_relid_attnam_index
> Welcome to psql, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help on internal slash commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> horde=> \d
> ERROR: SearchSysCache: recursive use of cache 4
> horde=> \q
>
> I've tried:
>
> bin/postgres -O -P -D `pwd`/data horde
>
> POSTGRES backend interactive interface
> $Revision: 1.155.2.1 $ $Date: 2000/08/30 21:19:32 $
>
> backend> reindex database horde;

Maybe you have to add FORCE option i.e.
reindex database horde force;

Regards.

Hiroshi Inoue