Matroska80 wrote:
> Hi i have a problem using tsearch2 with postgresql. Executing:
> SELECT to_tsquery('default','kj');
>
> return a
> cache lookup failed for function 141542.
Try the following:
SELECT oid,* FROM pg_proc WHERE proname='to_tsquery';
That should show whether there is a function with that OID.
> But it's strange this happens now but not before and nothing has done on
> database...some data break with tsearch2?
> I am using postgres 7.4.6 and no dump restore occurs before this error
> appear.
Either you have database corruption or something has clobbered your
function definition.
Oh, and upgrade to the latest 7.4.x series too - lots of bug-fixes
you'll want to get.
--
Richard Huxton
Archonet Ltd