pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMissing tsearch2 functions
4+ messages / 2 participants
[nested] [flat]
* Missing tsearch2 functions
@ 2010-03-18 16:41 Iñigo Martinez Lasala <imartinez@vectorsf.com>
0 siblings, 1 reply; 4+ messages in thread
From: Iñigo Martinez Lasala @ 2010-03-18 16:41 UTC (permalink / raw)
To: pgsql-admin
Hi everybody.
We are trying to migrate a gforge (again) with postgres 8.1/2 to
postgres 8.4.
We have adapted our schema in order to use tsearch2 from contrib folder
for not having to rewrite all functions. We have cleaned most of old
tsearch2 stuff, but some tsearch2 functions have dissapeared or at least
we don't know how to invoke with postgres 8.4
Theses functions are:
exectsq
rexectsq
concat
I've been unable to locate them at pg_catalog. I've not found reference
in tsearch2 documentation for exectsq and rexectsq. But concat should be
in place but it's missing!!
Any hint?
Thanks in advance.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Missing tsearch2 functions
@ 2010-03-18 16:46 Tom Lane <tgl@sss.pgh.pa.us>
parent: Iñigo Martinez Lasala <imartinez@vectorsf.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2010-03-18 16:46 UTC (permalink / raw)
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>; +Cc: pgsql-admin
=?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com> writes:
> We have adapted our schema in order to use tsearch2 from contrib folder
> for not having to rewrite all functions. We have cleaned most of old
> tsearch2 stuff, but some tsearch2 functions have dissapeared or at least
> we don't know how to invoke with postgres 8.4
> Theses functions are:
> exectsq
> rexectsq
> concat
None of those functions were ever meant to be invoked directly. Use the
corresponding operators (@@ and ||) instead.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Missing tsearch2 functions
@ 2010-03-18 19:39 Iñigo Martinez Lasala <imartinez@vectorsf.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Iñigo Martinez Lasala @ 2010-03-18 19:39 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Thank you, Tom.
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.
----- Mensaje original -----
De: "Tom Lane" <tgl@sss.pgh.pa.us>
Para: "Iñigo Martinez Lasala" <imartinez@vectorsf.com>
CC: "pgsql-admin" <pgsql-admin@postgresql.org>
Enviados: Jueves, 18 de Marzo 2010 17:46:46 GMT +01:00 Amsterdam / Berlín / Berna / Roma / Estocolmo / Viena
Asunto: Re: [ADMIN] Missing tsearch2 functions
=?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com> writes:
> We have adapted our schema in order to use tsearch2 from contrib folder
> for not having to rewrite all functions. We have cleaned most of old
> tsearch2 stuff, but some tsearch2 functions have dissapeared or at least
> we don't know how to invoke with postgres 8.4
> Theses functions are:
> exectsq
> rexectsq
> concat
None of those functions were ever meant to be invoked directly. Use the
corresponding operators (@@ and ||) instead.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Missing tsearch2 functions
@ 2010-03-18 19:48 Tom Lane <tgl@sss.pgh.pa.us>
parent: Iñigo Martinez Lasala <imartinez@vectorsf.com>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2010-03-18 19:48 UTC (permalink / raw)
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>; +Cc: pgsql-admin
=?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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-03-18 19:48 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-18 16:41 Missing tsearch2 functions Iñigo Martinez Lasala <imartinez@vectorsf.com>
2010-03-18 16:46 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-03-18 19:39 ` Iñigo Martinez Lasala <imartinez@vectorsf.com>
2010-03-18 19:48 ` Tom Lane <tgl@sss.pgh.pa.us>
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