Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 53E3C632330 for ; Thu, 18 Mar 2010 16:49:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73616-10 for ; Thu, 18 Mar 2010 19:48:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id CBDBD63221D for ; Thu, 18 Mar 2010 16:48:50 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o2IJmn3D016235; Thu, 18 Mar 2010 15:48:49 -0400 (EDT) To: =?utf-8?Q?I=C3=B1igo_Martinez_Lasala?= cc: pgsql-admin Subject: Re: Missing tsearch2 functions In-reply-to: <2087950908.632701268941188658.JavaMail.root@hermes.vectorsf.com> References: <2087950908.632701268941188658.JavaMail.root@hermes.vectorsf.com> Comments: In-reply-to =?utf-8?Q?I=C3=B1igo_Martinez_Lasala?= message dated "Thu, 18 Mar 2010 20:39:48 +0100" Date: Thu, 18 Mar 2010 15:48:49 -0400 Message-ID: <16234.1268941729@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/127 X-Sequence-Number: 33926 =?utf-8?Q?I=C3=B1igo_Martinez_Lasala?= writes: > In fact what was failing was the creation of operators || and @@. Both used the procedures concat, exectsq and rexectsq. So we can delete those operator creation sentences. Actually, it sounds to me like you might want to think about installing the newer version's contrib/tsearch2 first. See http://www.postgresql.org/docs/8.4/static/textsearch-migration.html In any case note that it's not expected that a dump containing the old tsearch2 object definitions will load without any noise. You should expect some errors like this. Just ignore the errors, unless they are preventing loading some object that doesn't belong to the old tsearch2 module. regards, tom lane