Re: [HACKERS] replicating tsearch2 across versions of postgres

2005-12-22 Thread Dave Cramer
Is it possible to just not replicate the internal tsearch tables ? Dave On 21-Dec-05, at 4:37 PM, Dave Cramer wrote: Thanks, that might be easier than first thought. Dave On 21-Dec-05, at 2:04 PM, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: Is it possible to add the old

[HACKERS] replicating tsearch2 across versions of postgres

2005-12-21 Thread Dave Cramer
I am getting the following error(s) when replicating tsearch2 from v 7.4.x to v 8.1.0remoteWorkerThread_1: copy from stdin on local node - PGRES_FATAL_ERROR ERROR:  function "spell_init(text)" does not [EMAIL PROTECTED] CONTEXT:  COPY pg_ts_dict, line 1, column dict_init: "spell_init(text)"the

Re: [HACKERS] replicating tsearch2 across versions of postgres

2005-12-21 Thread Tom Lane
Dave Cramer [EMAIL PROTECTED] writes: Is it possible to add the old signatures back for backward compatibility ? Something like a tsearch2-compat lib ? The old signatures were security holes. We are not going to put them back. I would suggest changing the functions on the 7.4 machine to the

Re: [HACKERS] replicating tsearch2 across versions of postgres

2005-12-21 Thread Dave Cramer
Thanks, that might be easier than first thought. Dave On 21-Dec-05, at 2:04 PM, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: Is it possible to add the old signatures back for backward compatibility ? Something like a tsearch2-compat lib ? The old signatures were security holes. We