> > I guess in the file "pg_proc_oid_index" should be the index. So how can I
> > recreate the index again so that it works fine again?
>
> Well. Try to
>
> create index proc_tmp on pg_proc (oid);
>
> Now cd to database dir and cp proc_tmp to pg_proc_oid_index and
>
> drop index proc_tmp;
>
> Let's know if it helps.
>
> Vadim
>
>
You may need to use postgres -O option to allow system table
modifications. Start postmaster with -o '-O'.
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
