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