Date: Thu, 16 Dec 2004 13:16:32 +0000 From: Vittorio <v.demartino2@virgilio.it> To: freebsd-questions@freebsd.org Subject: Postgresql extra functions Message-ID: <200412161316.32906.v.demartino2@virgilio.it>
next in thread | raw e-mail | index | archive | help
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 -------------------------------------------------------
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200412161316.32906.v.demartino2>