Horton

Re: [HACKERS] VACUUM ANALYZE Problem

James Hughes <jamesh@interpath.com>

View thread
From: James Hughes <jamesh@interpath.com>
To: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Cc: Bruce Momjian <maillist@candle.pha.pa.us>, PgSQL Hackers <hackers@postgreSQL.org>
Date: 1998-02-03T04:17:48Z
Lists: pgsql-hackers 
After poking arround some more, I found that the "vacuum analyze" is
causing problems with the "<" and ">" operators. The "> 0" in the SELECT
for "/d <table>" and "/dS" commands in psql cause the error. 

I verified that any simple query using the "<" or ">" operators fail 
with the same message...

	ERROR:  fmgr_info: function 0: cache lookup failed

 			...after using the "vacuum analyse" command.
But, only after vacuuming any relation that was created and populated by
me. Vacumming system catalogs poses no problems.

I did go back to 6.2.0. Found no problems there.


-James