From: | Herbert Liechti <Herbert(dot)Liechti(at)thinx(dot)ch> |
---|---|
To: | postgres <pgsql-general(at)postgreSQL(dot)org> |
Subject: | error while vacuuming |
Date: | 1999-08-26 13:53:51 |
Message-ID: | 37C546EF.C7E97634@thinx.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I try do vacuum a database:
[PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: ecoscan
ecoscan=> vacuum;
ERROR: Index pg_temp.3920.1 is not a btree
Any hints? Is it possible that the creation of temporary tables with
indexes clashes vacuum?
Thanks Herbie
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti E-Mail: Herbert(dot)Liechti(at)thinx(dot)ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Roderick A. Anderson | 1999-08-26 14:23:08 | Re: [GENERAL] Hardware optimising |
Previous Message | The Hermit Hacker | 1999-08-26 11:57:10 | Re: [GENERAL] Web pages |