Re: [HACKERS] VACUUM ANALYZE Problem - Mailing list pgsql-hackers

From James Hughes
Subject Re: [HACKERS] VACUUM ANALYZE Problem
Date
Msg-id Pine.LNX.3.93.980202230501.27867A-100000@xport.bluewall.com
Whole thread Raw
In response to Re: [HACKERS] VACUUM ANALYZE Problem  ("Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>)
Responses Re: [HACKERS] VACUUM ANALYZE Problem  (Bruce Momjian <maillist@candle.pha.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: "Vadim B. Mikheev"
Date:
Subject: vacuum analyze syntax in psql' help
Next
From: Bruce Momjian
Date:
Subject: Re: vacuum analyze syntax in psql' help