replicating tsearch2 across versions of postgres - Mailing list pgsql-hackers

From Dave Cramer
Subject replicating tsearch2 across versions of postgres
Date
Msg-id 20505474-A2AE-4C30-A245-EBDE23691352@fastcrypt.com
Whole thread Raw
Responses Re: replicating tsearch2 across versions of postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I am getting the following error(s) when replicating tsearch2 from v 7.4.x to v 8.1.0


remoteWorkerThread_1: copy from stdin on local node - PGRES_FATAL_ERROR ERROR:  function "spell_init(text)" does not exist@4000000043a9708d21558414 CONTEXT:  COPY pg_ts_dict, line 1, column dict_init: "spell_init(text)"

the problem is that the function signatures have changed

spell_init(text) is now spell_init(internal) so the function can't be found on the destination node.

My solution is to not replicate the internal tsearch2 tables. Is this going to be problematic ? 

Is it possible to add the old signatures back for backward compatibility ? Something like a tsearch2-compat lib ?


Dave

pgsql-hackers by date:

Previous
From: REYNAUD Jean-Samuel
Date:
Subject: Function call with offset and limit
Next
From: ohp@pyrenet.fr
Date:
Subject: where is the output