Odd Problems

Hi,

I have about 15 postgres databases, recently I have noticed on a few of
them odd errors.

Basically I have seen two different manifestations of the same problem
(which I think is index coruption).

In case 1, updates and or inserts fail due to a constraint on the table,
however they should be succeeding.

in the second case I get ERROR: could not access status of transaction
126746624 and an error following about a log file (in data/pg_clog)
that does not exisit.

In both case doing a REINDEX on the table fixes the problem. I have
had the problem happen about 5 times over the last week on 3 different
databases on different tables.

Running: PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC
i686-pc-linux-gnu-gcc (GCC) 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3,
pie-8.7.7.1)

Thanks
Ralph