Indeed, the problem has been tracked down to hardware. Bad RAM. I was (with
the kind help of some list members) able to rebuild the database without any
data loss.
Basically, what I had to do was update 'pg_class->relnatts' from 19 to 18.
This single change allowed me to actually work with the fraction table, but
without the ability to access the missing 'editdate' attribute.
Then, I tried to add a new column to 'fraction' using "ALTER TABLE fraction
ADD editdate ...", this barfed saying that the "editdate" colun already exists.
So, I then ran a "ALTER TABLE fraction RENAME editdate TO editdate2". This
command suceeeded, but I still couldn't see the missing attribute in \d
fraction. So, I re-updated pg_class and set relnatts back to 19. Now I could
see and access the 'editdate2' attribute! A simple rename command put
everything back together again.
Now I can sleep.
--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham
Extracta Mol�culas Naturais, Rio de Janeiro, Brasil
email: lapham@extracta.com.br web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------
