Ok, I found out what was going on with the tsearch2 module and reloading
after an upgrade to 8.0.1 from 7.4.1
The data now loads cleanly, and selects are fine.
HOWEVER, when I attempt an update, I issue the following SQL command (this
table has a tsearch2 vector in it:)
update post set
If I remove the full-text indexing from the table involved (remove the
indices and triggers) then the system is fine.
Somehow, it appears that there's some kind of internal consistency problem
with the tsearch2 package.
Attempts to recreate the indices (after dropping them) fail with the
Karl Denninger [EMAIL PROTECTED] writes:
Ok, I found out what was going on with the tsearch2 module and reloading
after an upgrade to 8.0.1 from 7.4.1
ERROR: cache lookup failed for function 36476
I think that tsearch2's control tables contain function OIDs, which
means that you can't just
This is know issue with OIDS.
You,probably, needed to apply regprocedure_7.4.patch.gz
patch from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
Oleg
On Thu, 3 Feb 2005, Karl Denninger wrote:
Ok, I found out what was going on with the tsearch2 module and reloading
after an upgrade
The patch is in the 8.0.1 version of Tsearch2 already.
The problem is that I have a dump from a 7.4.1 database taken with the
8.0.1 pg_dumpall that I need to be able to get back online on 8.0.x.
Is the only option to find all the functions in the tsearch.sql file, drop
them by hand, remove all
On Thu, 3 Feb 2005, Karl Denninger wrote:
The patch is in the 8.0.1 version of Tsearch2 already.
The problem is that I have a dump from a 7.4.1 database taken with the
8.0.1 pg_dumpall that I need to be able to get back online on 8.0.x.
you had to apply patch to 7.4.1 db before dumping or use