From: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
---|---|
To: | Machiel Richards <machielr(at)rdc(dot)co(dot)za> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: pgstatspack version? |
Date: | 2010-12-16 02:29:18 |
Message-ID: | AANLkTin2EGduFVzkTnHtK=uaU4LKA_9dnKdV4WrnRp5P@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Mon, Dec 13, 2010 at 3:54 AM, Machiel Richards <machielr(at)rdc(dot)co(dot)za> wrote:
> Hi All
>
> Does anybody perhaps know what version of PGSTATSPACK works
> specifically for postgresql-8.1 ?
I took a quick look at pgstatspack 2.2 with an install of Postgres
8.1.23. I got a whole bunch of errors when trying to install
pgstatspack; it looks to me like it won't work on 8.1, at least not
without some (minor?) tweaking of pgstatspack. For instance, I get:
psql:sql/pgstats_exist.sql:5: ERROR: function values("unknown") does not exist
Since the VALUES (...) construct was only introduced in Postgres 8.2.
I came across a whole bunch of other errors while trying to run
install_pgstats.sh, so I can't say how easy it would be to make it
work in 8.1 without further digging. There doesn't appear to be a
mailing list for that project, but the pgstatspack_README.txt does
give a few of the developers' email addresses you could try for
further help.
Josh
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Kupershmidt | 2010-12-16 02:51:39 | Re: create function and trigger to update column on table update |
Previous Message | Dara Olson | 2010-12-15 22:02:37 | create function and trigger to update column on table update |