Re: [HACKERS] VACUUM ANALYZE Problem

Поиск
Список
Период
Сортировка
От James Hughes
Тема Re: [HACKERS] VACUUM ANALYZE Problem
Дата
Msg-id Pine.LNX.3.93.980202230501.27867A-100000@xport.bluewall.com
обсуждение исходный текст
Ответ на Re: [HACKERS] VACUUM ANALYZE Problem  ("Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>)
Ответы Re: [HACKERS] VACUUM ANALYZE Problem  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Vadim B. Mikheev"
Дата:
Сообщение: vacuum analyze syntax in psql' help
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: vacuum analyze syntax in psql' help