"Gregory S. Williamson" <gsw@globexplorer.com> writes:
> I'll check into the temp files and the like in a bit -- the output from version() says:
> PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 (Mandrake Linux 9.1 3.2.2-3mdk)
> (1 row)
> so I am not sure if this 7.4.2 --
If it were 7.4.2 it would say so. You are in desperate need of an
update, as there are half a dozen known data-loss issues that are
corrected in the 7.4.x update series. The one that I now think bit
you is just one of them.
regards, tom lane