I don't use Debian, I use RH 9. I found looking around that the commit logs (pg_clog) directory was huge (500M). Which makes me wonder if it was just plain DB corruption, or if, when the "ALTER TABLE" was run, something had locked that instance of the DB, and everything since then had been running off of the temporary tablespace.
How often will OpenACS do a SQL commit?