Thread: cannot connect to database and strange error

Every time I try to connect to the database, I get this

bash$ psql whatsdown
FATAL 1:  FillScanKeyEntry: no procedure for operator 661
Connection to database 'whatsdown' failed.
FATAL 1:  FillScanKeyEntry: no procedure for operator 661


I haven't found info about the message.

This happen with only one database on the server. The others works
correctly.

thanks in advance

--
----------------------------------------------------------------
                                           Infogroup S.p.A.
   Massimiliano Panichi                    via delle Panche 140
   m.panichi@infogroup.it                  Tel: +390554365549
                                           Fax: +390554365735
----------------------------------------------------------------
Linux & Solaris: Why use Windows since there is a door ?
----------------------------------------------------------------

Massimiliano Panichi <m.panichi@infogroup.it> writes:
> bash$ psql whatsdown
> FATAL 1:  FillScanKeyEntry: no procedure for operator 661
> Connection to database 'whatsdown' failed.

Hmmm...

test72=# select * from pg_operator where oid = 661;
 oprname | oprowner | oprprec | oprkind | oprisleft | oprcanhash | oprleft | oprright | oprresult | oprcom | oprnegate
|oprlsortop | oprrsortop | oprcode |   oprrest   |     oprjoin 

---------+----------+---------+---------+-----------+------------+---------+----------+-----------+--------+-----------+------------+------------+---------+-------------+-----------------
 <=      |        1 |       0 | b       | t         | f          |      19 |       19 |        16 |    663 |       662
|         0 |          0 | namele  | scalarltsel | scalarltjoinsel 
(1 row)

I trust you didn't do anything as foolish as deliberately deleting
namele ;-)

It would seem that the pg_proc table has become corrupted in that
database.  If you are lucky, it's only the indexes on pg_proc that are
corrupt.  Try using REINDEX in a standalone backend to rebuild the
indexes.  See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/sql-reindex.html
for instructions on rebuilding system indexes (follow them carefully!)

If that doesn't work, I'm afraid you may be out of luck as far as doing
anything with that database is concerned.  I hope you have a backup...

            regards, tom lane