replicating tsearch2 across versions of postgres

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: replicating tsearch2 across versions of postgres
Date: 2005-12-21 17:45:09
Message-ID: 20505474-A2AE-4C30-A245-EBDE23691352@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-12-21 18:01:41 pgxs/windows
Previous Message REYNAUD Jean-Samuel 2005-12-21 17:44:33 Function call with offset and limit