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

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;
backend>

still get it ...

I'm either doing something wrong with REINDEXng the system tables, or this
isn't what hte problem is :(

v7.0.2+ database being run ...

Help? :(

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org