It seems to me that if the machine crashes in the middle of a transaction that there will be or is a very high chance of database corruption. I don't know if and how postgresql would detect and handle that after the system reboots. We are running mysql here and haven't had any data integrity problems.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org