Gordon Shannon <gordo169 at gmail.com> writes:
> I'm trying to run Slony 2.0.2 with Postgres 8.4.  I'm getting this error:
>
> 14 0716 03:41:58 ERROR  cleanupThread: "select nspname, relname from
> "_slony_cluster".TablesToVacuum();" - ERROR:  relation
> "pg_catalog.pg_autovacuum" does not exist
> 14 0716 03:41:58 LINE 1: select enabled from "pg_catalog".pg_autovacuum
> where vacreli...
> 14 0716 03:41:58                             ^
> 14 0716 03:41:58 QUERY:  select enabled from "pg_catalog".pg_autovacuum
> where vacrelid =  $1 
> 14 0716 03:41:58 CONTEXT:  PL/pgSQL function "shouldslonyvacuumtable" line
> 25 at SQL statement
> 14 0716 03:41:58 PL/pgSQL function "tablestovacuum" line 6 at IF
>
> It appears they may have dropped the use of the pg_autovacuum table in 8.4
> in favor of table creation storage parameters.

Happily, when I "forked" the function into 8.3 and 8.4 versions, it
turns out that the API was perfectly fine for either; indeed, the
change to pull data from pg_class rather than pg_autovacuum is
relatively minor within the function.

I just committed that to 2.0+HEAD.
-- 
output = ("cbbrowne" "@" "linuxdatabases.info")
http://linuxfinances.info/info/linuxdistributions.html
"Why use Windows, since there is a door?"
-- <fachat at galileo.rhein-neckar.de> Andre Fachat