"Gregory S. Williamson" <gsw@xxxxxxxxxxxxxxxx> 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
