Re: crosstab functions in postgres 8.1 - Mailing list pgsql-sql

From Tom Lane
Subject Re: crosstab functions in postgres 8.1
Date
Msg-id 8299.1212797527@sss.pgh.pa.us
Whole thread Raw
In response to crosstab functions in postgres 8.1  ("Chris Preston" <chris@thetrafalgartravel.com>)
List pgsql-sql
"Chris Preston" <chris@thetrafalgartravel.com> writes:
> I am  almost a newbie to postgres and only recently found out about one of
> the greatest function crosstab in postgres.  The problem is that I am using
> 8.1 and when I run the function I am getting an error relating to
> $libdir/tablefunc..   someone mentioned that it might be because I am using
> ver 8.1 and not 8.3

Well, since you didn't supply the exact error message, this is just a
guess; but it sounds like you haven't got the contrib/tablefunc module
installed in your 8.1 database, or at least haven't got it installed
correctly.  You need a tablefunc.so file that is compiled for 8.1
(copying the 8.3 version will almost certainly NOT work).
        regards, tom lane


pgsql-sql by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Trouble with exception
Next
From: Andreas
Date:
Subject: Need some magic with alternative rows