Problem: Error:relation "pg_autovacuum" does not exit?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • liming
    New Member
    • Dec 2009
    • 2

    Problem: Error:relation "pg_autovacuum" does not exit?

    I have installed postgresql 8.3.1,import data from a dB to another one.I work in pgadmin 3 . When I choose a table ,select the characteristic? it shows the problem below?
    Error:relation "pg_autovac uum" does not exit?
    Line1?select* from pg_autovacuum where vacrelid=26769: :oid

    what is the problem?
    How to solve it?
  • liming
    New Member
    • Dec 2009
    • 2

    #2
    I am sorry to see there is no one to answer my question!

    I think it is the answer to the question. From enterprise DB

    pg_autovacuum is no more available in PostgreSQL 8.4. i.e you no longer need to insert into the pg_autovacuum catalog to change per-table settings for autovacuum

    Now in 8.4, you can set autovacuum table configuration with ALTER TABLE / SET comman
    Please use the latest pgAdmin3, which comes as a part of installation of PostgreSQL 8.4 installation.

    Comment

    Working...