Re: Missing tsearch2 functions

Поиск
Список
Период
Сортировка
От Iñigo Martinez Lasala
Тема Re: Missing tsearch2 functions
Дата
Msg-id 2087950908.632701268941188658.JavaMail.root@hermes.vectorsf.com
обсуждение исходный текст
Ответ на Re: Missing tsearch2 functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Missing tsearch2 functions
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Abraham, Danny"
Дата:
Сообщение: WHo is locking me?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Missing tsearch2 functions