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@xxxxxxxxxxxxx> Para: "Iñigo Martinez Lasala" <imartinez@xxxxxxxxxxxx> CC: "pgsql-admin" <pgsql-admin@xxxxxxxxxxxxxx> Enviados: Jueves, 18 de Marzo 2010 17:46:46 GMT +01:00 Amsterdam / Berlín / Berna / Roma / Estocolmo / Viena Asunto: Re: Missing tsearch2 functions =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@xxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin