VACUUM ANALYZE Problem - Mailing list pgsql-hackers

From James Hughes
Subject VACUUM ANALYZE Problem
Date
Msg-id Pine.LNX.3.93.980201075642.11246A-100000@xport.bluewall.com
Whole thread Raw
List 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


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] regression tests
Next
From: "Vadim B. Mikheev"
Date:
Subject: Re: [HACKERS] VACUUM ANALYZE Problem