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