Обсуждение: replicating tsearch2 across versions of postgres
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
Dave Cramer <pg@fastcrypt.com> 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 new signatures --- see the 7.4.8 release notes. regards, tom lane
Thanks, that might be easier than first thought. Dave On 21-Dec-05, at 2:04 PM, Tom Lane wrote: > Dave Cramer <pg@fastcrypt.com> 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 > new signatures --- see the 7.4.8 release notes. > > regards, tom lane >
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 <pg@fastcrypt.com> 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 >> new signatures --- see the 7.4.8 release notes. >> >> regards, tom lane >> > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >