Re: pgstatspack version?

On Mon, Dec 13, 2010 at 3:54 AM, Machiel Richards <machielr@rdc.co.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