On Sun, 3 Jul 2005, Matthew Terenzio wrote:
I recently moved a database to a new machine:
PostgreSQL 7.4.7 on i386-portbld-freebsd5.3, compiled by GCC cc (GCC) 3.4.2
[FreeBSD] 20040728
any queries related to tsearch2 give me this error:
ERROR: cache lookup failed for function 17188
I am running the same versions of Postgres, Freebsd, etc
I guess my next move might be to run untsearch2.sql on both machines, do a
new dump , and try to rebuild tsearch2 from scratch on on both machines
Unless someone knows better?
yes, search archives and read about regprocedure_7.4.patch.gz
(http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/)
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
