VACUUM ANALYZE Problem

From: James Hughes <jamesh(at)interpath(dot)com>
To: PgSQL Hackers <hackers(at)postgreSQL(dot)org>
Subject: VACUUM ANALYZE Problem
Date: 1998-02-01 13:22:02
Message-ID: Pine.LNX.3.93.980201075642.11246A-100000@xport.bluewall.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim B. Mikheev 1998-02-01 15:45:33 Re: [HACKERS] VACUUM ANALYZE Problem
Previous Message The Hermit Hacker 1998-02-01 11:37:03 Re: [HACKERS] regression tests