[GENERAL] Lost indexes

2003-07-18 Thread Vilson farias
Greetings, I've been fighting against a very strange behaviour found in PostgreSQL 7.1.2 on a RedHat 6.2. I have a very simple table called site_site and I lost it's indexes everytime I run a vaccum. Do you know why this happens? Is there a way to get around or fix this kind of problem?I put a

Re: [GENERAL] Lost indexes

2003-07-18 Thread Richard Poole
On Fri, Jul 18, 2003 at 08:26:59AM -0300, Vilson farias wrote: Greetings, I've been fighting against a very strange behaviour found in PostgreSQL 7.1.2 on a RedHat 6.2. I have a very simple table called site_site and I lost it's indexes everytime I run a vaccum. Do you know why this