Re: [HACKERS] VACUUM ANALYZE Problem

Bruce Momjian <maillist@candle.pha.pa.us>

From: Bruce Momjian <maillist@candle.pha.pa.us>
To: jamesh@interpath.com (James Hughes)
Cc: vadim@sable.krasnoyarsk.su, hackers@postgreSQL.org
Date: 1998-02-03T19:25:56Z
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.

Glad it wasn't my vacuum code.  Lots of bad scan initializations.  Who
is working on that?  I think someone volunteered.

-- 
Bruce Momjian
maillist@candle.pha.pa.us