Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 01D6B632FB3
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Mar 2010 13:41:52 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 77275-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Mar 2010 16:41:38 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62])
	by mail.postgresql.org (Postfix) with ESMTP id 9C08B6338EB
	for <pgsql-admin@postgresql.org>; Thu, 18 Mar 2010 13:41:38 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by hermes.vectorsf.com (Postfix) with ESMTP id 0EBFC2480011
	for <pgsql-admin@postgresql.org>; Thu, 18 Mar 2010 17:41:33 +0100 (CET)
X-Virus-Scanned: amavisd-new at hermes.vectorsf.com
Received: from hermes.vectorsf.com ([127.0.0.1])
	by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id nBpah-Wf+OTZ for <pgsql-admin@postgresql.org>;
	Thu, 18 Mar 2010 17:41:29 +0100 (CET)
Received: from [10.70.4.200] (unknown [10.70.4.200])
	(Authenticated sender: imartinez)
	by hermes.vectorsf.com (Postfix) with ESMTP id E31512480006
	for <pgsql-admin@postgresql.org>; Thu, 18 Mar 2010 17:41:28 +0100 (CET)
Subject: Missing tsearch2 functions
From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
In-Reply-To: <1268903277.3827.1699.camel@ebony>
References: <4B9A6E8B.4050303@magneta.com.cy>
	<1268556612.3825.5025.camel@ebony>  <4B9DFD67.3050106@magneta.com.cy>
	<1268647021.3825.7469.camel@ebony>
	<7965A9DCF12CC14984420BCC37B1608F25AAFB989B@Elzar.grant.co.uk>
	<1268903277.3827.1699.camel@ebony>
Content-Type: multipart/alternative; boundary="=-1L3ozLPg3fJJaciofJF6"
Date: Thu, 18 Mar 2010 17:41:31 +0100
Message-ID: <1268930491.10034.63.camel@deimos>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.1 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.037 tagged_above=-10 required=5 tests=AWL=0.561,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/123
X-Sequence-Number: 33922


--=-1L3ozLPg3fJJaciofJF6
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

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. 

--=-1L3ozLPg3fJJaciofJF6
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.28.1">
</HEAD>
<BODY>
Hi everybody.<BR>
<BR>
We are trying to migrate a gforge (again) with postgres 8.1/2 to postgres 8.4.<BR>
<BR>
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<BR>
<BR>
Theses functions are:<BR>
exectsq<BR>
rexectsq<BR>
concat<BR>
<BR>
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!!<BR>
Any hint?<BR>
<BR>
Thanks in advance. 
</BODY>
</HTML>

--=-1L3ozLPg3fJJaciofJF6--