On Monday 16 February 2009 11:20:11 Alvaro Herrera wrote:
> Joshua D. Drake wrote:
> > Thanks for the work around, but that is ridiculous. I still say this is
> > a bug.
>
> Yes, which is why we fixed it on 8.4 by dropping pg_autovacuum.  (As
> Jaime and Tom say, it's actually pilot error, but the UI is crap so we
> fixed it.)
>

A little confused by this... 

robert=# select version();
                                               version                          
                     
-----------------------------------------------------------------------------------------------------
 PostgreSQL 8.4devel on i386-pc-solaris2.10, compiled by cc: Sun C 5.9 
SunOS_i386 2007/05/03, 32-bit
(1 row)

robert=# \d pg_catalog.pg_autovacuum
Did not find any relation named "pg_catalog.pg_autovacuum".
robert=# \dtS+ pg_catalog.pg_autovacuum
                          List of relations
   Schema   |     Name      | Type  | Owner  |  Size   | Description 
------------+---------------+-------+--------+---------+-------------
 pg_catalog | pg_autovacuum | table | robert | 0 bytes | 
(1 row)

I think this build is a couple weeks old, but is the pg_autovacuum table 
really gone in 8.4, or just deprecated? 

-- 
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to