From: Tom Lane <tgl@sss.pgh.pa.us>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Missing tsearch2 functions
Date: Thu, 18 Mar 2010 15:48:49 -0400
Message-ID: <16234.1268941729@sss.pgh.pa.us> (raw)
In-Reply-To: <2087950908.632701268941188658.JavaMail.root@hermes.vectorsf.com>
References: <2087950908.632701268941188658.JavaMail.root@hermes.vectorsf.com>
=?utf-8?Q?I=C3=B1igo_Martinez_Lasala?= <imartinez@vectorsf.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, imartinez@vectorsf.com
Subject: Re: Missing tsearch2 functions
In-Reply-To: <16234.1268941729@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox