From owner-freebsd-questions@FreeBSD.ORG  Thu Dec 16 12:16:52 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 2C08316A4CE
	for <freebsd-questions@freebsd.org>;
	Thu, 16 Dec 2004 12:16:52 +0000 (GMT)
Received: from vsmtp1.tin.it (vsmtp1.tin.it [212.216.176.141])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9BCF543D60
	for <freebsd-questions@freebsd.org>;
	Thu, 16 Dec 2004 12:16:51 +0000 (GMT)
	(envelope-from v.demartino2@virgilio.it)
Received: from a-fd1-70.tin.it (212.216.146.165) by vsmtp1.tin.it (7.0.027)
	id 41C082EF0007754C for freebsd-questions@freebsd.org;
	Thu, 16 Dec 2004 13:16:51 +0100
From: Vittorio <v.demartino2@virgilio.it>
Date: Thu, 16 Dec 2004 13:16:32 +0000
User-Agent: KMail/1.7.1
To: freebsd-questions@freebsd.org
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200412161316.32906.v.demartino2@virgilio.it>
Subject: Postgresql extra functions
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 16 Dec 2004 12:16:52 -0000


On a pentium 3 box I compiled and
installed /usr/ports/databases/postgresql 7.4.5 under FreeBSD 5.3.

Now I've been trying to set up the contrib/tablefunc stuff to use some
interesting functions in it (like crosstab), but there's something
wrong.
I mean that I've issued a "psql mydb < tablefunc.sql" but psql
 complains that all the functions like crosstab, crosstab3, etc do not
 exist, while, according to the docs, they **must exist before issuing
 the psql command mentioned above (I thought that they were already
 compiled somewhere but it isn't true!). I have tried to go under the
contrib/tablefunc directory the port and compile it as sugested in the
docs to no avail. It simply doesn't work.
Besides, I've just asked to the postgresql mailing to no avail either
above all because this supplementary installation is OS distro specific
(under a debian linux installation it all run smoothly!).

Please help

Vittorio

-------------------------------------------------------