Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group