VACUUM ANALYZE Problem

James Hughes <jamesh@interpath.com>

From: James Hughes <jamesh@interpath.com>
To: PgSQL Hackers <hackers@postgreSQL.org>
Date: 1998-02-01T13:22:02Z
Lists: pgsql-hackers
I am getting the error...

	ERROR:  fmgr_info: function 0: cache lookup failed

		...after creating a database, creating tables - indexes
and sequences, inserting data (with perl scripts) into 2 tables (570
records in one and 100 records in another), using "vacuum analyze" on
the database then trying "\d <tablename>" or "\dS". Running "vacuum"
alone is OK.

I run the query from psql.c:601 on the psql command line and get the
same result.   

I tried the same sequence with a small test database and only a few
records and there were no problems.

I am still looking into this and would appreciate any pointers.



-James